DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on FND_MSG_PUB

Line 145: -- FND_MSG_PUB.Add_Exc_Msg

141: -- ' output directory name is invalid. ' ||
142: -- ' Output directory must be one of the directory ' ||
143: -- ' value in v$parameter for name = utl_file_dir ';
144:
145: -- FND_MSG_PUB.Add_Exc_Msg
146: -- ( G_PKG_NAME ,
147: -- 'Open_Debug_Session' ,
148: -- l_error_mesg ) ;
149: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 239: -- FND_MSG_PUB.Add_Exc_Msg

235: Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240) ;
236:
237: FND_FILE.put_line(FND_FILE.LOG, G_PKG_NAME || '.Close_Debug_Session LOGGING ERROR => '||l_error_mesg);
238:
239: -- FND_MSG_PUB.Add_Exc_Msg
240: -- ( G_PKG_NAME ,
241: -- 'Close_Debug_Session' ,
242: -- l_error_mesg ) ;
243: --

Line 292: -- FND_MSG_PUB.Add_Exc_Msg

288:
289: FND_FILE.put_line(FND_FILE.LOG, G_PKG_NAME || '.Write_Debug LOGGING ERROR => '||l_error_mesg);
290:
291: --
292: -- FND_MSG_PUB.Add_Exc_Msg
293: -- ( G_PKG_NAME ,
294: -- 'Write_Debug' ,
295: -- l_error_mesg ) ;
296: --

Line 4237: IF FND_MSG_PUB.Check_Msg_Level

4233: Write_Debug('When Others in SetChangeApprovalStatus ' || SQLERRM );
4234: END IF ;
4235:
4236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4237: IF FND_MSG_PUB.Check_Msg_Level
4238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4239: THEN
4240: FND_MSG_PUB.Add_Exc_Msg
4241: ( G_PKG_NAME ,

Line 4238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4234: END IF ;
4235:
4236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4237: IF FND_MSG_PUB.Check_Msg_Level
4238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4239: THEN
4240: FND_MSG_PUB.Add_Exc_Msg
4241: ( G_PKG_NAME ,
4242: l_api_name

Line 4240: FND_MSG_PUB.Add_Exc_Msg

4236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4237: IF FND_MSG_PUB.Check_Msg_Level
4238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4239: THEN
4240: FND_MSG_PUB.Add_Exc_Msg
4241: ( G_PKG_NAME ,
4242: l_api_name
4243: );
4244: END IF;

Line 4344: IF FND_MSG_PUB.Check_Msg_Level

4340: Write_Debug('When Others in SyncLineApprovalStatus ' || SQLERRM );
4341: END IF ;
4342:
4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4344: IF FND_MSG_PUB.Check_Msg_Level
4345: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4346: THEN
4347: FND_MSG_PUB.Add_Exc_Msg
4348: ( G_PKG_NAME ,

Line 4345: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4341: END IF ;
4342:
4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4344: IF FND_MSG_PUB.Check_Msg_Level
4345: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4346: THEN
4347: FND_MSG_PUB.Add_Exc_Msg
4348: ( G_PKG_NAME ,
4349: l_api_name

Line 4347: FND_MSG_PUB.Add_Exc_Msg

4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4344: IF FND_MSG_PUB.Check_Msg_Level
4345: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4346: THEN
4347: FND_MSG_PUB.Add_Exc_Msg
4348: ( G_PKG_NAME ,
4349: l_api_name
4350: );
4351: END IF;

Line 5724: IF FND_MSG_PUB.Check_Msg_Level

5720: END IF ;
5721:
5722:
5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5724: IF FND_MSG_PUB.Check_Msg_Level
5725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5726: THEN
5727: FND_MSG_PUB.Add_Exc_Msg
5728: ( G_PKG_NAME ,

Line 5725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5721:
5722:
5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5724: IF FND_MSG_PUB.Check_Msg_Level
5725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5726: THEN
5727: FND_MSG_PUB.Add_Exc_Msg
5728: ( G_PKG_NAME ,
5729: l_api_name

Line 5727: FND_MSG_PUB.Add_Exc_Msg

5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5724: IF FND_MSG_PUB.Check_Msg_Level
5725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5726: THEN
5727: FND_MSG_PUB.Add_Exc_Msg
5728: ( G_PKG_NAME ,
5729: l_api_name
5730: );
5731: END IF;

Line 5775: FND_MSG_PUB.Add ;

5771: l_return_status := FND_API.G_RET_STS_ERROR ;
5772:
5773: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_REQDATE_INVALID') ;
5774: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', step_rec.step_seq_num );
5775: FND_MSG_PUB.Add ;
5776:
5777: END IF ;
5778:
5779: -- Step Req Date should be greater than or equal to

Line 5789: FND_MSG_PUB.Add ;

5785: l_return_status := FND_API.G_RET_STS_ERROR ;
5786:
5787: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_REQDATE_LESS') ;
5788: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', step_rec.step_seq_num );
5789: FND_MSG_PUB.Add ;
5790:
5791:
5792: END IF ;
5793:

Line 5884: FND_MSG_PUB.Add ;

5880: ) ;
5881:
5882: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_LN_NOT_ABLE_TO_START') ;
5883: FND_MESSAGE.SET_TOKEN('LINE_SEQ_NUM', l_line_sequence_number );
5884: FND_MSG_PUB.Add ;
5885:
5886: ELSE
5887:
5888: -- Set Error Message for Header

Line 5890: FND_MSG_PUB.Add ;

5886: ELSE
5887:
5888: -- Set Error Message for Header
5889: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_NOT_ABLE_TO_START') ;
5890: FND_MSG_PUB.Add ;
5891:
5892: END IF ;
5893:
5894: END LOOP ;

Line 5911: FND_MSG_PUB.Add ;

5907: l_return_status := FND_API.G_RET_STS_ERROR ;
5908:
5909: -- Set Error Message for Header
5910: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_NOT_INSTANCE') ;
5911: FND_MSG_PUB.Add ;
5912:
5913: END LOOP ;
5914:
5915:

Line 5992: FND_MSG_PUB.Add ;

5988:
5989: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_LN_INVALID_ASSIGNEE') ;
5990: FND_MESSAGE.SET_TOKEN('LINE_SEQ_NUM', l_line_sequence_number );
5991: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', route_rec.step_seq_num );
5992: FND_MSG_PUB.Add ;
5993:
5994: ELSE
5995:
5996: -- Set Error Message for Header

Line 5999: FND_MSG_PUB.Add ;

5995:
5996: -- Set Error Message for Header
5997: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_INVALID_ASSIGNEE') ;
5998: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', route_rec.step_seq_num );
5999: FND_MSG_PUB.Add ;
6000:
6001: END IF ;
6002:
6003:

Line 6045: FND_MSG_PUB.Add ;

6041: l_return_status := FND_API.G_RET_STS_ERROR ;
6042:
6043: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_MANDAT_ASSIGN_MISS') ;
6044: --fnd_message.SET_TOKEN ('STEP_NO',route_rec.STEP_SEQ_NUM , TRUE);
6045: FND_MSG_PUB.Add ;
6046:
6047: END IF ;
6048:
6049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 6258: IF FND_MSG_PUB.Check_Msg_Level

6254: EXCEPTION
6255: WHEN OTHERS THEN
6256:
6257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6258: IF FND_MSG_PUB.Check_Msg_Level
6259: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6260: THEN
6261: FND_MSG_PUB.Add_Exc_Msg
6262: ( G_PKG_NAME ,

Line 6259: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6255: WHEN OTHERS THEN
6256:
6257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6258: IF FND_MSG_PUB.Check_Msg_Level
6259: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6260: THEN
6261: FND_MSG_PUB.Add_Exc_Msg
6262: ( G_PKG_NAME ,
6263: l_api_name

Line 6261: FND_MSG_PUB.Add_Exc_Msg

6257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6258: IF FND_MSG_PUB.Check_Msg_Level
6259: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6260: THEN
6261: FND_MSG_PUB.Add_Exc_Msg
6262: ( G_PKG_NAME ,
6263: l_api_name
6264: );
6265: END IF;

Line 6321: FND_MSG_PUB.Add ;

6317:
6318: x_return_status := FND_API.G_RET_STS_ERROR ;
6319:
6320: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_WF_NOT_RUNNING') ;
6321: FND_MSG_PUB.Add ;
6322:
6323: END IF ;
6324:
6325: EXCEPTION

Line 6329: IF FND_MSG_PUB.Check_Msg_Level

6325: EXCEPTION
6326: WHEN OTHERS THEN
6327:
6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6329: IF FND_MSG_PUB.Check_Msg_Level
6330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6331: THEN
6332: FND_MSG_PUB.Add_Exc_Msg
6333: ( G_PKG_NAME ,

Line 6330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6326: WHEN OTHERS THEN
6327:
6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6329: IF FND_MSG_PUB.Check_Msg_Level
6330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6331: THEN
6332: FND_MSG_PUB.Add_Exc_Msg
6333: ( G_PKG_NAME ,
6334: l_api_name

Line 6332: FND_MSG_PUB.Add_Exc_Msg

6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6329: IF FND_MSG_PUB.Check_Msg_Level
6330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6331: THEN
6332: FND_MSG_PUB.Add_Exc_Msg
6333: ( G_PKG_NAME ,
6334: l_api_name
6335: );
6336: END IF;

Line 6443: IF FND_MSG_PUB.Check_Msg_Level

6439: EXCEPTION
6440: WHEN OTHERS THEN
6441:
6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6443: IF FND_MSG_PUB.Check_Msg_Level
6444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6445: THEN
6446: FND_MSG_PUB.Add_Exc_Msg
6447: ( G_PKG_NAME ,

Line 6444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6440: WHEN OTHERS THEN
6441:
6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6443: IF FND_MSG_PUB.Check_Msg_Level
6444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6445: THEN
6446: FND_MSG_PUB.Add_Exc_Msg
6447: ( G_PKG_NAME ,
6448: l_api_name

Line 6446: FND_MSG_PUB.Add_Exc_Msg

6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6443: IF FND_MSG_PUB.Check_Msg_Level
6444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6445: THEN
6446: FND_MSG_PUB.Add_Exc_Msg
6447: ( G_PKG_NAME ,
6448: l_api_name
6449: );
6450: END IF;

Line 6558: IF FND_MSG_PUB.Check_Msg_Level

6554: EXCEPTION
6555: WHEN OTHERS THEN
6556:
6557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6558: IF FND_MSG_PUB.Check_Msg_Level
6559: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6560: THEN
6561: FND_MSG_PUB.Add_Exc_Msg
6562: ( G_PKG_NAME ,

Line 6559: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6555: WHEN OTHERS THEN
6556:
6557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6558: IF FND_MSG_PUB.Check_Msg_Level
6559: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6560: THEN
6561: FND_MSG_PUB.Add_Exc_Msg
6562: ( G_PKG_NAME ,
6563: l_api_name

Line 6561: FND_MSG_PUB.Add_Exc_Msg

6557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6558: IF FND_MSG_PUB.Check_Msg_Level
6559: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6560: THEN
6561: FND_MSG_PUB.Add_Exc_Msg
6562: ( G_PKG_NAME ,
6563: l_api_name
6564: );
6565: END IF;

Line 6727: IF FND_MSG_PUB.Check_Msg_Level

6723: EXCEPTION
6724: WHEN OTHERS THEN
6725:
6726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6727: IF FND_MSG_PUB.Check_Msg_Level
6728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6729: THEN
6730: FND_MSG_PUB.Add_Exc_Msg
6731: ( G_PKG_NAME ,

Line 6728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6724: WHEN OTHERS THEN
6725:
6726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6727: IF FND_MSG_PUB.Check_Msg_Level
6728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6729: THEN
6730: FND_MSG_PUB.Add_Exc_Msg
6731: ( G_PKG_NAME ,
6732: l_api_name

Line 6730: FND_MSG_PUB.Add_Exc_Msg

6726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6727: IF FND_MSG_PUB.Check_Msg_Level
6728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6729: THEN
6730: FND_MSG_PUB.Add_Exc_Msg
6731: ( G_PKG_NAME ,
6732: l_api_name
6733: );
6734: END IF;

Line 6815: -- FND_MSG_PUB.initialize ;

6811: -- Initialize Line Item Key
6812: l_line_item_key := null ;
6813:
6814: -- Start Change Line Workflows
6815: -- FND_MSG_PUB.initialize ;
6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE

Line 6880: IF FND_MSG_PUB.Check_Msg_Level

6876: WHEN OTHERS THEN
6877: -- ROLLBACK ;
6878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6879:
6880: IF FND_MSG_PUB.Check_Msg_Level
6881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6882: THEN
6883: FND_MSG_PUB.Add_Exc_Msg
6884: ( G_PKG_NAME

Line 6881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6877: -- ROLLBACK ;
6878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6879:
6880: IF FND_MSG_PUB.Check_Msg_Level
6881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6882: THEN
6883: FND_MSG_PUB.Add_Exc_Msg
6884: ( G_PKG_NAME
6885: , l_api_name

Line 6883: FND_MSG_PUB.Add_Exc_Msg

6879:
6880: IF FND_MSG_PUB.Check_Msg_Level
6881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6882: THEN
6883: FND_MSG_PUB.Add_Exc_Msg
6884: ( G_PKG_NAME
6885: , l_api_name
6886: );
6887: END IF;

Line 6988: IF FND_MSG_PUB.Check_Msg_Level

6984: EXCEPTION
6985: WHEN OTHERS THEN
6986:
6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6988: IF FND_MSG_PUB.Check_Msg_Level
6989: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6990: THEN
6991: FND_MSG_PUB.Add_Exc_Msg
6992: ( G_PKG_NAME ,

Line 6989: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6985: WHEN OTHERS THEN
6986:
6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6988: IF FND_MSG_PUB.Check_Msg_Level
6989: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6990: THEN
6991: FND_MSG_PUB.Add_Exc_Msg
6992: ( G_PKG_NAME ,
6993: l_api_name

Line 6991: FND_MSG_PUB.Add_Exc_Msg

6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6988: IF FND_MSG_PUB.Check_Msg_Level
6989: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6990: THEN
6991: FND_MSG_PUB.Add_Exc_Msg
6992: ( G_PKG_NAME ,
6993: l_api_name
6994: );
6995: END IF;

Line 7170: IF FND_MSG_PUB.Check_Msg_Level

7166: EXCEPTION
7167: WHEN OTHERS THEN
7168:
7169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7170: IF FND_MSG_PUB.Check_Msg_Level
7171: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7172: THEN
7173: FND_MSG_PUB.Add_Exc_Msg
7174: ( G_PKG_NAME ,

Line 7171: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7167: WHEN OTHERS THEN
7168:
7169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7170: IF FND_MSG_PUB.Check_Msg_Level
7171: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7172: THEN
7173: FND_MSG_PUB.Add_Exc_Msg
7174: ( G_PKG_NAME ,
7175: l_api_name

Line 7173: FND_MSG_PUB.Add_Exc_Msg

7169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7170: IF FND_MSG_PUB.Check_Msg_Level
7171: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7172: THEN
7173: FND_MSG_PUB.Add_Exc_Msg
7174: ( G_PKG_NAME ,
7175: l_api_name
7176: );
7177: END IF;

Line 7296: IF FND_MSG_PUB.Check_Msg_Level

7292: EXCEPTION
7293: WHEN OTHERS THEN
7294:
7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7296: IF FND_MSG_PUB.Check_Msg_Level
7297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7298: THEN
7299: FND_MSG_PUB.Add_Exc_Msg
7300: ( G_PKG_NAME ,

Line 7297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7293: WHEN OTHERS THEN
7294:
7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7296: IF FND_MSG_PUB.Check_Msg_Level
7297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7298: THEN
7299: FND_MSG_PUB.Add_Exc_Msg
7300: ( G_PKG_NAME ,
7301: l_api_name

Line 7299: FND_MSG_PUB.Add_Exc_Msg

7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7296: IF FND_MSG_PUB.Check_Msg_Level
7297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7298: THEN
7299: FND_MSG_PUB.Add_Exc_Msg
7300: ( G_PKG_NAME ,
7301: l_api_name
7302: );
7303: END IF;

Line 7408: IF FND_MSG_PUB.Check_Msg_Level

7404: EXCEPTION
7405: WHEN OTHERS THEN
7406:
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg
7412: ( G_PKG_NAME ,

Line 7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7405: WHEN OTHERS THEN
7406:
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg
7412: ( G_PKG_NAME ,
7413: l_api_name

Line 7411: FND_MSG_PUB.Add_Exc_Msg

7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg
7412: ( G_PKG_NAME ,
7413: l_api_name
7414: );
7415: END IF;

Line 7525: IF FND_MSG_PUB.Check_Msg_Level

7521: EXCEPTION
7522: WHEN OTHERS THEN
7523:
7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7525: IF FND_MSG_PUB.Check_Msg_Level
7526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg
7529: ( G_PKG_NAME ,

Line 7526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7522: WHEN OTHERS THEN
7523:
7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7525: IF FND_MSG_PUB.Check_Msg_Level
7526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg
7529: ( G_PKG_NAME ,
7530: l_api_name

Line 7528: FND_MSG_PUB.Add_Exc_Msg

7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7525: IF FND_MSG_PUB.Check_Msg_Level
7526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg
7529: ( G_PKG_NAME ,
7530: l_api_name
7531: );
7532: END IF;

Line 7727: IF FND_MSG_PUB.Check_Msg_Level

7723: WHEN OTHERS THEN
7724:
7725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7726:
7727: IF FND_MSG_PUB.Check_Msg_Level
7728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7729: THEN
7730: FND_MSG_PUB.Add_Exc_Msg
7731: ( G_PKG_NAME

Line 7728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7724:
7725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7726:
7727: IF FND_MSG_PUB.Check_Msg_Level
7728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7729: THEN
7730: FND_MSG_PUB.Add_Exc_Msg
7731: ( G_PKG_NAME
7732: , l_api_name

Line 7730: FND_MSG_PUB.Add_Exc_Msg

7726:
7727: IF FND_MSG_PUB.Check_Msg_Level
7728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7729: THEN
7730: FND_MSG_PUB.Add_Exc_Msg
7731: ( G_PKG_NAME
7732: , l_api_name
7733: );
7734: END IF;

Line 7893: IF FND_MSG_PUB.Check_Msg_Level

7889: WHEN OTHERS THEN
7890:
7891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7892:
7893: IF FND_MSG_PUB.Check_Msg_Level
7894: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7895: THEN
7896: FND_MSG_PUB.Add_Exc_Msg
7897: ( G_PKG_NAME

Line 7894: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7890:
7891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7892:
7893: IF FND_MSG_PUB.Check_Msg_Level
7894: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7895: THEN
7896: FND_MSG_PUB.Add_Exc_Msg
7897: ( G_PKG_NAME
7898: , l_api_name

Line 7896: FND_MSG_PUB.Add_Exc_Msg

7892:
7893: IF FND_MSG_PUB.Check_Msg_Level
7894: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7895: THEN
7896: FND_MSG_PUB.Add_Exc_Msg
7897: ( G_PKG_NAME
7898: , l_api_name
7899: );
7900: END IF;

Line 8036: IF FND_MSG_PUB.Check_Msg_Level

8032: -- ROLLBACK ;
8033:
8034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8035:
8036: IF FND_MSG_PUB.Check_Msg_Level
8037: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8038: THEN
8039: FND_MSG_PUB.Add_Exc_Msg
8040: ( G_PKG_NAME

Line 8037: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8033:
8034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8035:
8036: IF FND_MSG_PUB.Check_Msg_Level
8037: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8038: THEN
8039: FND_MSG_PUB.Add_Exc_Msg
8040: ( G_PKG_NAME
8041: , l_api_name

Line 8039: FND_MSG_PUB.Add_Exc_Msg

8035:
8036: IF FND_MSG_PUB.Check_Msg_Level
8037: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8038: THEN
8039: FND_MSG_PUB.Add_Exc_Msg
8040: ( G_PKG_NAME
8041: , l_api_name
8042: );
8043: END IF;

Line 8211: IF FND_MSG_PUB.Check_Msg_Level

8207: WHEN OTHERS THEN
8208:
8209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8210:
8211: IF FND_MSG_PUB.Check_Msg_Level
8212: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8213: THEN
8214: FND_MSG_PUB.Add_Exc_Msg
8215: ( G_PKG_NAME

Line 8212: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8208:
8209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8210:
8211: IF FND_MSG_PUB.Check_Msg_Level
8212: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8213: THEN
8214: FND_MSG_PUB.Add_Exc_Msg
8215: ( G_PKG_NAME
8216: , l_api_name

Line 8214: FND_MSG_PUB.Add_Exc_Msg

8210:
8211: IF FND_MSG_PUB.Check_Msg_Level
8212: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8213: THEN
8214: FND_MSG_PUB.Add_Exc_Msg
8215: ( G_PKG_NAME
8216: , l_api_name
8217: );
8218: END IF;

Line 8703: IF FND_MSG_PUB.Check_Msg_Level

8699: END IF ;
8700:
8701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8702:
8703: IF FND_MSG_PUB.Check_Msg_Level
8704: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8705: THEN
8706: FND_MSG_PUB.Add_Exc_Msg
8707: ( G_PKG_NAME

Line 8704: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8700:
8701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8702:
8703: IF FND_MSG_PUB.Check_Msg_Level
8704: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8705: THEN
8706: FND_MSG_PUB.Add_Exc_Msg
8707: ( G_PKG_NAME
8708: , l_api_name

Line 8706: FND_MSG_PUB.Add_Exc_Msg

8702:
8703: IF FND_MSG_PUB.Check_Msg_Level
8704: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8705: THEN
8706: FND_MSG_PUB.Add_Exc_Msg
8707: ( G_PKG_NAME
8708: , l_api_name
8709: );
8710: END IF;

Line 8776: IF FND_MSG_PUB.Check_Msg_Level

8772: WHEN OTHERS THEN
8773:
8774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8775:
8776: IF FND_MSG_PUB.Check_Msg_Level
8777: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8778: THEN
8779: FND_MSG_PUB.Add_Exc_Msg
8780: ( G_PKG_NAME

Line 8777: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8773:
8774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8775:
8776: IF FND_MSG_PUB.Check_Msg_Level
8777: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8778: THEN
8779: FND_MSG_PUB.Add_Exc_Msg
8780: ( G_PKG_NAME
8781: , l_api_name

Line 8779: FND_MSG_PUB.Add_Exc_Msg

8775:
8776: IF FND_MSG_PUB.Check_Msg_Level
8777: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8778: THEN
8779: FND_MSG_PUB.Add_Exc_Msg
8780: ( G_PKG_NAME
8781: , l_api_name
8782: );
8783: END IF;

Line 8872: -- FND_MSG_PUB.initialize ;

8868:
8869: END IF ;
8870:
8871:
8872: -- FND_MSG_PUB.initialize ;
8873: Eng_Workflow_Util.StartWorkflow
8874: ( p_api_version => 1.0
8875: , p_init_msg_list => FND_API.G_FALSE
8876: , p_commit => FND_API.G_FALSE

Line 8931: IF FND_MSG_PUB.Check_Msg_Level

8927: -- ROLLBACK ;
8928:
8929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8930:
8931: IF FND_MSG_PUB.Check_Msg_Level
8932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8933: THEN
8934: FND_MSG_PUB.Add_Exc_Msg
8935: ( G_PKG_NAME

Line 8932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8928:
8929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8930:
8931: IF FND_MSG_PUB.Check_Msg_Level
8932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8933: THEN
8934: FND_MSG_PUB.Add_Exc_Msg
8935: ( G_PKG_NAME
8936: , l_api_name

Line 8934: FND_MSG_PUB.Add_Exc_Msg

8930:
8931: IF FND_MSG_PUB.Check_Msg_Level
8932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8933: THEN
8934: FND_MSG_PUB.Add_Exc_Msg
8935: ( G_PKG_NAME
8936: , l_api_name
8937: );
8938: END IF;

Line 9044: IF FND_MSG_PUB.Check_Msg_Level

9040: WHEN OTHERS THEN
9041:
9042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9043:
9044: IF FND_MSG_PUB.Check_Msg_Level
9045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9046: THEN
9047: FND_MSG_PUB.Add_Exc_Msg
9048: ( G_PKG_NAME

Line 9045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9041:
9042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9043:
9044: IF FND_MSG_PUB.Check_Msg_Level
9045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9046: THEN
9047: FND_MSG_PUB.Add_Exc_Msg
9048: ( G_PKG_NAME
9049: , l_api_name

Line 9047: FND_MSG_PUB.Add_Exc_Msg

9043:
9044: IF FND_MSG_PUB.Check_Msg_Level
9045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9046: THEN
9047: FND_MSG_PUB.Add_Exc_Msg
9048: ( G_PKG_NAME
9049: , l_api_name
9050: );
9051: END IF;

Line 9124: IF FND_MSG_PUB.Check_Msg_Level

9120: WHEN OTHERS THEN
9121:
9122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9123:
9124: IF FND_MSG_PUB.Check_Msg_Level
9125: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9126: THEN
9127: FND_MSG_PUB.Add_Exc_Msg
9128: ( G_PKG_NAME

Line 9125: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9121:
9122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9123:
9124: IF FND_MSG_PUB.Check_Msg_Level
9125: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9126: THEN
9127: FND_MSG_PUB.Add_Exc_Msg
9128: ( G_PKG_NAME
9129: , l_api_name

Line 9127: FND_MSG_PUB.Add_Exc_Msg

9123:
9124: IF FND_MSG_PUB.Check_Msg_Level
9125: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9126: THEN
9127: FND_MSG_PUB.Add_Exc_Msg
9128: ( G_PKG_NAME
9129: , l_api_name
9130: );
9131: END IF;

Line 9219: -- FND_MSG_PUB.initialize ;

9215: -- Initialize Line Item Key
9216: l_line_item_key := null ;
9217:
9218: -- Start Change Line Workflows
9219: -- FND_MSG_PUB.initialize ;
9220: Eng_Workflow_Util.StartWorkflow
9221: ( p_api_version => 1.0
9222: , p_init_msg_list => FND_API.G_FALSE
9223: , p_commit => FND_API.G_FALSE

Line 9284: IF FND_MSG_PUB.Check_Msg_Level

9280: ROLLBACK ;
9281:
9282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9283:
9284: IF FND_MSG_PUB.Check_Msg_Level
9285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9286: THEN
9287: FND_MSG_PUB.Add_Exc_Msg
9288: ( G_PKG_NAME

Line 9285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9281:
9282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9283:
9284: IF FND_MSG_PUB.Check_Msg_Level
9285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9286: THEN
9287: FND_MSG_PUB.Add_Exc_Msg
9288: ( G_PKG_NAME
9289: , l_api_name

Line 9287: FND_MSG_PUB.Add_Exc_Msg

9283:
9284: IF FND_MSG_PUB.Check_Msg_Level
9285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9286: THEN
9287: FND_MSG_PUB.Add_Exc_Msg
9288: ( G_PKG_NAME
9289: , l_api_name
9290: );
9291: END IF;

Line 9349: IF FND_MSG_PUB.Check_Msg_Level

9345: WHEN OTHERS THEN
9346:
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9348:
9349: IF FND_MSG_PUB.Check_Msg_Level
9350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9351: THEN
9352: FND_MSG_PUB.Add_Exc_Msg
9353: ( G_PKG_NAME

Line 9350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9346:
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9348:
9349: IF FND_MSG_PUB.Check_Msg_Level
9350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9351: THEN
9352: FND_MSG_PUB.Add_Exc_Msg
9353: ( G_PKG_NAME
9354: , l_api_name

Line 9352: FND_MSG_PUB.Add_Exc_Msg

9348:
9349: IF FND_MSG_PUB.Check_Msg_Level
9350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9351: THEN
9352: FND_MSG_PUB.Add_Exc_Msg
9353: ( G_PKG_NAME
9354: , l_api_name
9355: );
9356: END IF;

Line 9534: IF FND_MSG_PUB.Check_Msg_Level

9530: WHEN OTHERS THEN
9531:
9532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9533:
9534: IF FND_MSG_PUB.Check_Msg_Level
9535: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9536: THEN
9537: FND_MSG_PUB.Add_Exc_Msg
9538: ( G_PKG_NAME

Line 9535: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9531:
9532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9533:
9534: IF FND_MSG_PUB.Check_Msg_Level
9535: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9536: THEN
9537: FND_MSG_PUB.Add_Exc_Msg
9538: ( G_PKG_NAME
9539: , l_api_name

Line 9537: FND_MSG_PUB.Add_Exc_Msg

9533:
9534: IF FND_MSG_PUB.Check_Msg_Level
9535: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9536: THEN
9537: FND_MSG_PUB.Add_Exc_Msg
9538: ( G_PKG_NAME
9539: , l_api_name
9540: );
9541: END IF;

Line 10848: -- FND_MSG_PUB.initialize ;

10844:
10845: BEGIN
10846: l_return_status := FND_API.G_RET_STS_SUCCESS ;
10847:
10848: -- FND_MSG_PUB.initialize ;
10849: Eng_Workflow_Util.StartWorkflow
10850: ( p_api_version => 1.0
10851: , p_init_msg_list => FND_API.G_FALSE
10852: , p_commit => FND_API.G_FALSE

Line 10909: IF FND_MSG_PUB.Check_Msg_Level

10905: WHEN OTHERS THEN
10906:
10907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10908:
10909: IF FND_MSG_PUB.Check_Msg_Level
10910: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10911: THEN
10912: FND_MSG_PUB.Add_Exc_Msg
10913: ( G_PKG_NAME

Line 10910: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

10906:
10907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10908:
10909: IF FND_MSG_PUB.Check_Msg_Level
10910: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10911: THEN
10912: FND_MSG_PUB.Add_Exc_Msg
10913: ( G_PKG_NAME
10914: , l_api_name

Line 10912: FND_MSG_PUB.Add_Exc_Msg

10908:
10909: IF FND_MSG_PUB.Check_Msg_Level
10910: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10911: THEN
10912: FND_MSG_PUB.Add_Exc_Msg
10913: ( G_PKG_NAME
10914: , l_api_name
10915: );
10916: END IF;

Line 11225: IF FND_MSG_PUB.Check_Msg_Level

11221: WHEN OTHERS THEN
11222:
11223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11224:
11225: IF FND_MSG_PUB.Check_Msg_Level
11226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11227: THEN
11228: FND_MSG_PUB.Add_Exc_Msg
11229: ( G_PKG_NAME

Line 11226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11222:
11223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11224:
11225: IF FND_MSG_PUB.Check_Msg_Level
11226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11227: THEN
11228: FND_MSG_PUB.Add_Exc_Msg
11229: ( G_PKG_NAME
11230: , l_api_name

Line 11228: FND_MSG_PUB.Add_Exc_Msg

11224:
11225: IF FND_MSG_PUB.Check_Msg_Level
11226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11227: THEN
11228: FND_MSG_PUB.Add_Exc_Msg
11229: ( G_PKG_NAME
11230: , l_api_name
11231: );
11232: END IF;

Line 11335: IF FND_MSG_PUB.Check_Msg_Level

11331: WHEN OTHERS THEN
11332:
11333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11334:
11335: IF FND_MSG_PUB.Check_Msg_Level
11336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11337: THEN
11338: FND_MSG_PUB.Add_Exc_Msg
11339: ( G_PKG_NAME

Line 11336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11332:
11333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11334:
11335: IF FND_MSG_PUB.Check_Msg_Level
11336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11337: THEN
11338: FND_MSG_PUB.Add_Exc_Msg
11339: ( G_PKG_NAME
11340: , l_api_name

Line 11338: FND_MSG_PUB.Add_Exc_Msg

11334:
11335: IF FND_MSG_PUB.Check_Msg_Level
11336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11337: THEN
11338: FND_MSG_PUB.Add_Exc_Msg
11339: ( G_PKG_NAME
11340: , l_api_name
11341: );
11342: END IF;

Line 11394: FND_MSG_PUB.initialize;

11390:
11391:
11392: -- Initialize message list if p_init_msg_list is set to TRUE.
11393: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11394: FND_MSG_PUB.initialize;
11395: END IF ;
11396:
11397: -- Initialize API return status to success
11398: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11463: FND_MSG_PUB.Count_And_Get

11459: -- COMMIT WORK;
11460: -- END IF;
11461:
11462: -- Standard call to get message count and if count is 1, get message info.
11463: FND_MSG_PUB.Count_And_Get
11464: ( p_count => x_msg_count
11465: , p_data => x_msg_data
11466: );
11467:

Line 11473: FND_MSG_PUB.Count_And_Get

11469: WHEN FND_API.G_EXC_ERROR THEN
11470: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11471: x_return_status := FND_API.G_RET_STS_ERROR ;
11472:
11473: FND_MSG_PUB.Count_And_Get
11474: ( p_count => x_msg_count
11475: , p_data => x_msg_data
11476: );
11477:

Line 11482: FND_MSG_PUB.Count_And_Get

11478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11479: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11481:
11482: FND_MSG_PUB.Count_And_Get
11483: ( p_count => x_msg_count
11484: , p_data => x_msg_data
11485: );
11486:

Line 11491: FND_MSG_PUB.Count_And_Get

11487: WHEN OTHERS THEN
11488: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11490:
11491: FND_MSG_PUB.Count_And_Get
11492: ( p_count => x_msg_count
11493: , p_data => x_msg_data
11494: );
11495:

Line 11496: IF FND_MSG_PUB.Check_Msg_Level

11492: ( p_count => x_msg_count
11493: , p_data => x_msg_data
11494: );
11495:
11496: IF FND_MSG_PUB.Check_Msg_Level
11497: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11498: THEN
11499: FND_MSG_PUB.Add_Exc_Msg
11500: ( G_PKG_NAME

Line 11497: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11493: , p_data => x_msg_data
11494: );
11495:
11496: IF FND_MSG_PUB.Check_Msg_Level
11497: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11498: THEN
11499: FND_MSG_PUB.Add_Exc_Msg
11500: ( G_PKG_NAME
11501: , l_api_name

Line 11499: FND_MSG_PUB.Add_Exc_Msg

11495:
11496: IF FND_MSG_PUB.Check_Msg_Level
11497: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11498: THEN
11499: FND_MSG_PUB.Add_Exc_Msg
11500: ( G_PKG_NAME
11501: , l_api_name
11502: );
11503: END IF;

Line 11505: FND_MSG_PUB.Count_And_Get

11501: , l_api_name
11502: );
11503: END IF;
11504:
11505: FND_MSG_PUB.Count_And_Get
11506: ( p_count => x_msg_count
11507: , p_data => x_msg_data
11508: );
11509:

Line 11680: FND_MSG_PUB.initialize;

11676: END IF;
11677:
11678: -- Initialize message list if p_init_msg_list is set to TRUE.
11679: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11680: FND_MSG_PUB.initialize;
11681: END IF ;
11682:
11683:
11684:

Line 12370: FND_MSG_PUB.Count_And_Get

12366: COMMIT WORK;
12367: END IF;
12368:
12369: -- Standard call to get message count and if count is 1, get message info.
12370: FND_MSG_PUB.Count_And_Get
12371: ( p_count => x_msg_count
12372: , p_data => x_msg_data
12373: );
12374:

Line 12393: FND_MSG_PUB.Count_And_Get

12389: END IF;
12390:
12391: x_return_status := FND_API.G_RET_STS_ERROR ;
12392:
12393: FND_MSG_PUB.Count_And_Get
12394: ( p_count => x_msg_count
12395: , p_data => x_msg_data
12396: );
12397:

Line 12413: FND_MSG_PUB.Count_And_Get

12409: END IF;
12410:
12411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12412:
12413: FND_MSG_PUB.Count_And_Get
12414: ( p_count => x_msg_count
12415: , p_data => x_msg_data
12416: );
12417:

Line 12433: FND_MSG_PUB.Count_And_Get

12429: END IF;
12430:
12431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12432:
12433: FND_MSG_PUB.Count_And_Get
12434: ( p_count => x_msg_count
12435: , p_data => x_msg_data
12436: );
12437:

Line 12438: IF FND_MSG_PUB.Check_Msg_Level

12434: ( p_count => x_msg_count
12435: , p_data => x_msg_data
12436: );
12437:
12438: IF FND_MSG_PUB.Check_Msg_Level
12439: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12440: THEN
12441: FND_MSG_PUB.Add_Exc_Msg
12442: ( G_PKG_NAME

Line 12439: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

12435: , p_data => x_msg_data
12436: );
12437:
12438: IF FND_MSG_PUB.Check_Msg_Level
12439: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12440: THEN
12441: FND_MSG_PUB.Add_Exc_Msg
12442: ( G_PKG_NAME
12443: , l_api_name

Line 12441: FND_MSG_PUB.Add_Exc_Msg

12437:
12438: IF FND_MSG_PUB.Check_Msg_Level
12439: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12440: THEN
12441: FND_MSG_PUB.Add_Exc_Msg
12442: ( G_PKG_NAME
12443: , l_api_name
12444: );
12445: END IF;

Line 12447: FND_MSG_PUB.Count_And_Get

12443: , l_api_name
12444: );
12445: END IF;
12446:
12447: FND_MSG_PUB.Count_And_Get
12448: ( p_count => x_msg_count
12449: , p_data => x_msg_data
12450: );
12451:

Line 12526: FND_MSG_PUB.initialize;

12522: END IF;
12523:
12524: -- Initialize message list if p_init_msg_list is set to TRUE.
12525: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12526: FND_MSG_PUB.initialize;
12527: END IF ;
12528:
12529:
12530: -- For Test/Debug

Line 13075: FND_MSG_PUB.Count_And_Get

13071:
13072: END IF;
13073:
13074: -- Standard call to get message count and if count is 1, get message info.
13075: FND_MSG_PUB.Count_And_Get
13076: ( p_count => x_msg_count
13077: , p_data => x_msg_data
13078: );
13079:

Line 13098: FND_MSG_PUB.Count_And_Get

13094: END IF;
13095:
13096: x_return_status := FND_API.G_RET_STS_ERROR ;
13097:
13098: FND_MSG_PUB.Count_And_Get
13099: ( p_count => x_msg_count
13100: , p_data => x_msg_data
13101: );
13102:

Line 13118: FND_MSG_PUB.Count_And_Get

13114: END IF;
13115:
13116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13117:
13118: FND_MSG_PUB.Count_And_Get
13119: ( p_count => x_msg_count
13120: , p_data => x_msg_data
13121: );
13122:

Line 13138: FND_MSG_PUB.Count_And_Get

13134: END IF;
13135:
13136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13137:
13138: FND_MSG_PUB.Count_And_Get
13139: ( p_count => x_msg_count
13140: , p_data => x_msg_data
13141: );
13142:

Line 13143: IF FND_MSG_PUB.Check_Msg_Level

13139: ( p_count => x_msg_count
13140: , p_data => x_msg_data
13141: );
13142:
13143: IF FND_MSG_PUB.Check_Msg_Level
13144: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13145: THEN
13146: FND_MSG_PUB.Add_Exc_Msg
13147: ( G_PKG_NAME

Line 13144: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

13140: , p_data => x_msg_data
13141: );
13142:
13143: IF FND_MSG_PUB.Check_Msg_Level
13144: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13145: THEN
13146: FND_MSG_PUB.Add_Exc_Msg
13147: ( G_PKG_NAME
13148: , l_api_name

Line 13146: FND_MSG_PUB.Add_Exc_Msg

13142:
13143: IF FND_MSG_PUB.Check_Msg_Level
13144: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13145: THEN
13146: FND_MSG_PUB.Add_Exc_Msg
13147: ( G_PKG_NAME
13148: , l_api_name
13149: );
13150: END IF;

Line 13152: FND_MSG_PUB.Count_And_Get

13148: , l_api_name
13149: );
13150: END IF;
13151:
13152: FND_MSG_PUB.Count_And_Get
13153: ( p_count => x_msg_count
13154: , p_data => x_msg_data
13155: );
13156:

Line 13554: FND_MSG_PUB.Count_And_Get

13550: WHEN FND_API.G_EXC_ERROR THEN
13551: ROLLBACK TO AbortWorkflow_Util ;
13552: x_return_status := FND_API.G_RET_STS_ERROR ;
13553:
13554: FND_MSG_PUB.Count_And_Get
13555: ( p_count => x_msg_count
13556: , p_data => x_msg_data
13557: );
13558: END reassignRoutePeople;

Line 13737: FND_MSG_PUB.initialize;

13733: END IF;
13734:
13735: -- Initialize message list if p_init_msg_list is set to TRUE.
13736: IF FND_API.to_Boolean( p_init_msg_list ) THEN
13737: FND_MSG_PUB.initialize;
13738: END IF ;
13739:
13740:
13741: -- For Test/Debug

Line 14120: FND_MSG_PUB.Count_And_Get

14116:
14117: END IF;
14118:
14119: -- Standard call to get message count and if count is 1, get message info.
14120: FND_MSG_PUB.Count_And_Get
14121: ( p_count => x_msg_count
14122: , p_data => x_msg_data
14123: );
14124:

Line 14141: FND_MSG_PUB.Count_And_Get

14137: ROLLBACK TO GrantObjectRoles ;
14138: END IF ;
14139: x_return_status := FND_API.G_RET_STS_ERROR ;
14140:
14141: FND_MSG_PUB.Count_And_Get
14142: ( p_count => x_msg_count
14143: , p_data => x_msg_data
14144: );
14145:

Line 14164: FND_MSG_PUB.Count_And_Get

14160: END IF ;
14161:
14162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14163:
14164: FND_MSG_PUB.Count_And_Get
14165: ( p_count => x_msg_count
14166: , p_data => x_msg_data
14167: );
14168:

Line 14187: FND_MSG_PUB.Count_And_Get

14183:
14184: END IF ;
14185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14186:
14187: FND_MSG_PUB.Count_And_Get
14188: ( p_count => x_msg_count
14189: , p_data => x_msg_data
14190: );
14191:

Line 14192: IF FND_MSG_PUB.Check_Msg_Level

14188: ( p_count => x_msg_count
14189: , p_data => x_msg_data
14190: );
14191:
14192: IF FND_MSG_PUB.Check_Msg_Level
14193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14194: THEN
14195: FND_MSG_PUB.Add_Exc_Msg
14196: ( G_PKG_NAME

Line 14193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

14189: , p_data => x_msg_data
14190: );
14191:
14192: IF FND_MSG_PUB.Check_Msg_Level
14193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14194: THEN
14195: FND_MSG_PUB.Add_Exc_Msg
14196: ( G_PKG_NAME
14197: , l_api_name

Line 14195: FND_MSG_PUB.Add_Exc_Msg

14191:
14192: IF FND_MSG_PUB.Check_Msg_Level
14193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14194: THEN
14195: FND_MSG_PUB.Add_Exc_Msg
14196: ( G_PKG_NAME
14197: , l_api_name
14198: );
14199: END IF;

Line 14201: FND_MSG_PUB.Count_And_Get

14197: , l_api_name
14198: );
14199: END IF;
14200:
14201: FND_MSG_PUB.Count_And_Get
14202: ( p_count => x_msg_count
14203: , p_data => x_msg_data
14204: );
14205:

Line 14694: FND_MSG_PUB.initialize;

14690: END IF;
14691:
14692: -- Initialize message list if p_init_msg_list is set to TRUE.
14693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
14694: FND_MSG_PUB.initialize;
14695: END IF ;
14696:
14697:
14698: -- For Test/Debug

Line 15052: FND_MSG_PUB.Count_And_Get

15048:
15049: END IF;
15050:
15051: -- Standard call to get message count and if count is 1, get message info.
15052: FND_MSG_PUB.Count_And_Get
15053: ( p_count => x_msg_count
15054: , p_data => x_msg_data
15055: );
15056:

Line 15073: FND_MSG_PUB.Count_And_Get

15069: ROLLBACK TO RevokeObjectRoles ;
15070: END IF ;
15071: x_return_status := FND_API.G_RET_STS_ERROR ;
15072:
15073: FND_MSG_PUB.Count_And_Get
15074: ( p_count => x_msg_count
15075: , p_data => x_msg_data
15076: );
15077:

Line 15095: FND_MSG_PUB.Count_And_Get

15091: END IF ;
15092:
15093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15094:
15095: FND_MSG_PUB.Count_And_Get
15096: ( p_count => x_msg_count
15097: , p_data => x_msg_data
15098: );
15099:

Line 15117: FND_MSG_PUB.Count_And_Get

15113: END IF ;
15114:
15115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15116:
15117: FND_MSG_PUB.Count_And_Get
15118: ( p_count => x_msg_count
15119: , p_data => x_msg_data
15120: );
15121:

Line 15122: IF FND_MSG_PUB.Check_Msg_Level

15118: ( p_count => x_msg_count
15119: , p_data => x_msg_data
15120: );
15121:
15122: IF FND_MSG_PUB.Check_Msg_Level
15123: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15124: THEN
15125: FND_MSG_PUB.Add_Exc_Msg
15126: ( G_PKG_NAME

Line 15123: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

15119: , p_data => x_msg_data
15120: );
15121:
15122: IF FND_MSG_PUB.Check_Msg_Level
15123: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15124: THEN
15125: FND_MSG_PUB.Add_Exc_Msg
15126: ( G_PKG_NAME
15127: , l_api_name

Line 15125: FND_MSG_PUB.Add_Exc_Msg

15121:
15122: IF FND_MSG_PUB.Check_Msg_Level
15123: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15124: THEN
15125: FND_MSG_PUB.Add_Exc_Msg
15126: ( G_PKG_NAME
15127: , l_api_name
15128: );
15129: END IF;

Line 15131: FND_MSG_PUB.Count_And_Get

15127: , l_api_name
15128: );
15129: END IF;
15130:
15131: FND_MSG_PUB.Count_And_Get
15132: ( p_count => x_msg_count
15133: , p_data => x_msg_data
15134: );
15135: