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 8772: IF FND_MSG_PUB.Check_Msg_Level

8768: END IF ;
8769:
8770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8771:
8772: IF FND_MSG_PUB.Check_Msg_Level
8773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8774: THEN
8775: FND_MSG_PUB.Add_Exc_Msg
8776: ( G_PKG_NAME

Line 8773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8769:
8770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8771:
8772: IF FND_MSG_PUB.Check_Msg_Level
8773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8774: THEN
8775: FND_MSG_PUB.Add_Exc_Msg
8776: ( G_PKG_NAME
8777: , l_api_name

Line 8775: FND_MSG_PUB.Add_Exc_Msg

8771:
8772: IF FND_MSG_PUB.Check_Msg_Level
8773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8774: THEN
8775: FND_MSG_PUB.Add_Exc_Msg
8776: ( G_PKG_NAME
8777: , l_api_name
8778: );
8779: END IF;

Line 8852: IF FND_MSG_PUB.Check_Msg_Level

8848: WHEN OTHERS THEN
8849:
8850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8851:
8852: IF FND_MSG_PUB.Check_Msg_Level
8853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8854: THEN
8855: FND_MSG_PUB.Add_Exc_Msg
8856: ( G_PKG_NAME

Line 8853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8849:
8850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8851:
8852: IF FND_MSG_PUB.Check_Msg_Level
8853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8854: THEN
8855: FND_MSG_PUB.Add_Exc_Msg
8856: ( G_PKG_NAME
8857: , l_api_name

Line 8855: FND_MSG_PUB.Add_Exc_Msg

8851:
8852: IF FND_MSG_PUB.Check_Msg_Level
8853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8854: THEN
8855: FND_MSG_PUB.Add_Exc_Msg
8856: ( G_PKG_NAME
8857: , l_api_name
8858: );
8859: END IF;

Line 8948: -- FND_MSG_PUB.initialize ;

8944:
8945: END IF ;
8946:
8947:
8948: -- FND_MSG_PUB.initialize ;
8949: Eng_Workflow_Util.StartWorkflow
8950: ( p_api_version => 1.0
8951: , p_init_msg_list => FND_API.G_FALSE
8952: , p_commit => FND_API.G_FALSE

Line 9007: IF FND_MSG_PUB.Check_Msg_Level

9003: -- ROLLBACK ;
9004:
9005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9006:
9007: IF FND_MSG_PUB.Check_Msg_Level
9008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9009: THEN
9010: FND_MSG_PUB.Add_Exc_Msg
9011: ( G_PKG_NAME

Line 9008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9004:
9005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9006:
9007: IF FND_MSG_PUB.Check_Msg_Level
9008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9009: THEN
9010: FND_MSG_PUB.Add_Exc_Msg
9011: ( G_PKG_NAME
9012: , l_api_name

Line 9010: FND_MSG_PUB.Add_Exc_Msg

9006:
9007: IF FND_MSG_PUB.Check_Msg_Level
9008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9009: THEN
9010: FND_MSG_PUB.Add_Exc_Msg
9011: ( G_PKG_NAME
9012: , l_api_name
9013: );
9014: END IF;

Line 9120: IF FND_MSG_PUB.Check_Msg_Level

9116: WHEN OTHERS THEN
9117:
9118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9119:
9120: IF FND_MSG_PUB.Check_Msg_Level
9121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9122: THEN
9123: FND_MSG_PUB.Add_Exc_Msg
9124: ( G_PKG_NAME

Line 9121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9117:
9118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9119:
9120: IF FND_MSG_PUB.Check_Msg_Level
9121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9122: THEN
9123: FND_MSG_PUB.Add_Exc_Msg
9124: ( G_PKG_NAME
9125: , l_api_name

Line 9123: FND_MSG_PUB.Add_Exc_Msg

9119:
9120: IF FND_MSG_PUB.Check_Msg_Level
9121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9122: THEN
9123: FND_MSG_PUB.Add_Exc_Msg
9124: ( G_PKG_NAME
9125: , l_api_name
9126: );
9127: END IF;

Line 9200: IF FND_MSG_PUB.Check_Msg_Level

9196: WHEN OTHERS THEN
9197:
9198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9199:
9200: IF FND_MSG_PUB.Check_Msg_Level
9201: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9202: THEN
9203: FND_MSG_PUB.Add_Exc_Msg
9204: ( G_PKG_NAME

Line 9201: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9197:
9198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9199:
9200: IF FND_MSG_PUB.Check_Msg_Level
9201: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9202: THEN
9203: FND_MSG_PUB.Add_Exc_Msg
9204: ( G_PKG_NAME
9205: , l_api_name

Line 9203: FND_MSG_PUB.Add_Exc_Msg

9199:
9200: IF FND_MSG_PUB.Check_Msg_Level
9201: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9202: THEN
9203: FND_MSG_PUB.Add_Exc_Msg
9204: ( G_PKG_NAME
9205: , l_api_name
9206: );
9207: END IF;

Line 9295: -- FND_MSG_PUB.initialize ;

9291: -- Initialize Line Item Key
9292: l_line_item_key := null ;
9293:
9294: -- Start Change Line Workflows
9295: -- FND_MSG_PUB.initialize ;
9296: Eng_Workflow_Util.StartWorkflow
9297: ( p_api_version => 1.0
9298: , p_init_msg_list => FND_API.G_FALSE
9299: , p_commit => FND_API.G_FALSE

Line 9360: IF FND_MSG_PUB.Check_Msg_Level

9356: ROLLBACK ;
9357:
9358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9359:
9360: IF FND_MSG_PUB.Check_Msg_Level
9361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9362: THEN
9363: FND_MSG_PUB.Add_Exc_Msg
9364: ( G_PKG_NAME

Line 9361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9357:
9358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9359:
9360: IF FND_MSG_PUB.Check_Msg_Level
9361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9362: THEN
9363: FND_MSG_PUB.Add_Exc_Msg
9364: ( G_PKG_NAME
9365: , l_api_name

Line 9363: FND_MSG_PUB.Add_Exc_Msg

9359:
9360: IF FND_MSG_PUB.Check_Msg_Level
9361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9362: THEN
9363: FND_MSG_PUB.Add_Exc_Msg
9364: ( G_PKG_NAME
9365: , l_api_name
9366: );
9367: END IF;

Line 9425: IF FND_MSG_PUB.Check_Msg_Level

9421: WHEN OTHERS THEN
9422:
9423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9424:
9425: IF FND_MSG_PUB.Check_Msg_Level
9426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9427: THEN
9428: FND_MSG_PUB.Add_Exc_Msg
9429: ( G_PKG_NAME

Line 9426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9422:
9423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9424:
9425: IF FND_MSG_PUB.Check_Msg_Level
9426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9427: THEN
9428: FND_MSG_PUB.Add_Exc_Msg
9429: ( G_PKG_NAME
9430: , l_api_name

Line 9428: FND_MSG_PUB.Add_Exc_Msg

9424:
9425: IF FND_MSG_PUB.Check_Msg_Level
9426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9427: THEN
9428: FND_MSG_PUB.Add_Exc_Msg
9429: ( G_PKG_NAME
9430: , l_api_name
9431: );
9432: END IF;

Line 9610: IF FND_MSG_PUB.Check_Msg_Level

9606: WHEN OTHERS THEN
9607:
9608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9609:
9610: IF FND_MSG_PUB.Check_Msg_Level
9611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9612: THEN
9613: FND_MSG_PUB.Add_Exc_Msg
9614: ( G_PKG_NAME

Line 9611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9607:
9608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9609:
9610: IF FND_MSG_PUB.Check_Msg_Level
9611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9612: THEN
9613: FND_MSG_PUB.Add_Exc_Msg
9614: ( G_PKG_NAME
9615: , l_api_name

Line 9613: FND_MSG_PUB.Add_Exc_Msg

9609:
9610: IF FND_MSG_PUB.Check_Msg_Level
9611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9612: THEN
9613: FND_MSG_PUB.Add_Exc_Msg
9614: ( G_PKG_NAME
9615: , l_api_name
9616: );
9617: END IF;

Line 10924: -- FND_MSG_PUB.initialize ;

10920:
10921: BEGIN
10922: l_return_status := FND_API.G_RET_STS_SUCCESS ;
10923:
10924: -- FND_MSG_PUB.initialize ;
10925: Eng_Workflow_Util.StartWorkflow
10926: ( p_api_version => 1.0
10927: , p_init_msg_list => FND_API.G_FALSE
10928: , p_commit => FND_API.G_FALSE

Line 10985: IF FND_MSG_PUB.Check_Msg_Level

10981: WHEN OTHERS THEN
10982:
10983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10984:
10985: IF FND_MSG_PUB.Check_Msg_Level
10986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10987: THEN
10988: FND_MSG_PUB.Add_Exc_Msg
10989: ( G_PKG_NAME

Line 10986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

10982:
10983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10984:
10985: IF FND_MSG_PUB.Check_Msg_Level
10986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10987: THEN
10988: FND_MSG_PUB.Add_Exc_Msg
10989: ( G_PKG_NAME
10990: , l_api_name

Line 10988: FND_MSG_PUB.Add_Exc_Msg

10984:
10985: IF FND_MSG_PUB.Check_Msg_Level
10986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10987: THEN
10988: FND_MSG_PUB.Add_Exc_Msg
10989: ( G_PKG_NAME
10990: , l_api_name
10991: );
10992: END IF;

Line 11301: IF FND_MSG_PUB.Check_Msg_Level

11297: WHEN OTHERS THEN
11298:
11299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11300:
11301: IF FND_MSG_PUB.Check_Msg_Level
11302: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11303: THEN
11304: FND_MSG_PUB.Add_Exc_Msg
11305: ( G_PKG_NAME

Line 11302: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11298:
11299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11300:
11301: IF FND_MSG_PUB.Check_Msg_Level
11302: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11303: THEN
11304: FND_MSG_PUB.Add_Exc_Msg
11305: ( G_PKG_NAME
11306: , l_api_name

Line 11304: FND_MSG_PUB.Add_Exc_Msg

11300:
11301: IF FND_MSG_PUB.Check_Msg_Level
11302: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11303: THEN
11304: FND_MSG_PUB.Add_Exc_Msg
11305: ( G_PKG_NAME
11306: , l_api_name
11307: );
11308: END IF;

Line 11411: IF FND_MSG_PUB.Check_Msg_Level

11407: WHEN OTHERS THEN
11408:
11409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11410:
11411: IF FND_MSG_PUB.Check_Msg_Level
11412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11413: THEN
11414: FND_MSG_PUB.Add_Exc_Msg
11415: ( G_PKG_NAME

Line 11412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11408:
11409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11410:
11411: IF FND_MSG_PUB.Check_Msg_Level
11412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11413: THEN
11414: FND_MSG_PUB.Add_Exc_Msg
11415: ( G_PKG_NAME
11416: , l_api_name

Line 11414: FND_MSG_PUB.Add_Exc_Msg

11410:
11411: IF FND_MSG_PUB.Check_Msg_Level
11412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11413: THEN
11414: FND_MSG_PUB.Add_Exc_Msg
11415: ( G_PKG_NAME
11416: , l_api_name
11417: );
11418: END IF;

Line 11470: FND_MSG_PUB.initialize;

11466:
11467:
11468: -- Initialize message list if p_init_msg_list is set to TRUE.
11469: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11470: FND_MSG_PUB.initialize;
11471: END IF ;
11472:
11473: -- Initialize API return status to success
11474: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11539: FND_MSG_PUB.Count_And_Get

11535: -- COMMIT WORK;
11536: -- END IF;
11537:
11538: -- Standard call to get message count and if count is 1, get message info.
11539: FND_MSG_PUB.Count_And_Get
11540: ( p_count => x_msg_count
11541: , p_data => x_msg_data
11542: );
11543:

Line 11549: FND_MSG_PUB.Count_And_Get

11545: WHEN FND_API.G_EXC_ERROR THEN
11546: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11547: x_return_status := FND_API.G_RET_STS_ERROR ;
11548:
11549: FND_MSG_PUB.Count_And_Get
11550: ( p_count => x_msg_count
11551: , p_data => x_msg_data
11552: );
11553:

Line 11558: FND_MSG_PUB.Count_And_Get

11554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11555: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11557:
11558: FND_MSG_PUB.Count_And_Get
11559: ( p_count => x_msg_count
11560: , p_data => x_msg_data
11561: );
11562:

Line 11567: FND_MSG_PUB.Count_And_Get

11563: WHEN OTHERS THEN
11564: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11566:
11567: FND_MSG_PUB.Count_And_Get
11568: ( p_count => x_msg_count
11569: , p_data => x_msg_data
11570: );
11571:

Line 11572: IF FND_MSG_PUB.Check_Msg_Level

11568: ( p_count => x_msg_count
11569: , p_data => x_msg_data
11570: );
11571:
11572: IF FND_MSG_PUB.Check_Msg_Level
11573: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11574: THEN
11575: FND_MSG_PUB.Add_Exc_Msg
11576: ( G_PKG_NAME

Line 11573: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11569: , p_data => x_msg_data
11570: );
11571:
11572: IF FND_MSG_PUB.Check_Msg_Level
11573: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11574: THEN
11575: FND_MSG_PUB.Add_Exc_Msg
11576: ( G_PKG_NAME
11577: , l_api_name

Line 11575: FND_MSG_PUB.Add_Exc_Msg

11571:
11572: IF FND_MSG_PUB.Check_Msg_Level
11573: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11574: THEN
11575: FND_MSG_PUB.Add_Exc_Msg
11576: ( G_PKG_NAME
11577: , l_api_name
11578: );
11579: END IF;

Line 11581: FND_MSG_PUB.Count_And_Get

11577: , l_api_name
11578: );
11579: END IF;
11580:
11581: FND_MSG_PUB.Count_And_Get
11582: ( p_count => x_msg_count
11583: , p_data => x_msg_data
11584: );
11585:

Line 11756: FND_MSG_PUB.initialize;

11752: END IF;
11753:
11754: -- Initialize message list if p_init_msg_list is set to TRUE.
11755: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11756: FND_MSG_PUB.initialize;
11757: END IF ;
11758:
11759:
11760:

Line 12446: FND_MSG_PUB.Count_And_Get

12442: COMMIT WORK;
12443: END IF;
12444:
12445: -- Standard call to get message count and if count is 1, get message info.
12446: FND_MSG_PUB.Count_And_Get
12447: ( p_count => x_msg_count
12448: , p_data => x_msg_data
12449: );
12450:

Line 12469: FND_MSG_PUB.Count_And_Get

12465: END IF;
12466:
12467: x_return_status := FND_API.G_RET_STS_ERROR ;
12468:
12469: FND_MSG_PUB.Count_And_Get
12470: ( p_count => x_msg_count
12471: , p_data => x_msg_data
12472: );
12473:

Line 12489: FND_MSG_PUB.Count_And_Get

12485: END IF;
12486:
12487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12488:
12489: FND_MSG_PUB.Count_And_Get
12490: ( p_count => x_msg_count
12491: , p_data => x_msg_data
12492: );
12493:

Line 12509: FND_MSG_PUB.Count_And_Get

12505: END IF;
12506:
12507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12508:
12509: FND_MSG_PUB.Count_And_Get
12510: ( p_count => x_msg_count
12511: , p_data => x_msg_data
12512: );
12513:

Line 12514: IF FND_MSG_PUB.Check_Msg_Level

12510: ( p_count => x_msg_count
12511: , p_data => x_msg_data
12512: );
12513:
12514: IF FND_MSG_PUB.Check_Msg_Level
12515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12516: THEN
12517: FND_MSG_PUB.Add_Exc_Msg
12518: ( G_PKG_NAME

Line 12515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

12511: , p_data => x_msg_data
12512: );
12513:
12514: IF FND_MSG_PUB.Check_Msg_Level
12515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12516: THEN
12517: FND_MSG_PUB.Add_Exc_Msg
12518: ( G_PKG_NAME
12519: , l_api_name

Line 12517: FND_MSG_PUB.Add_Exc_Msg

12513:
12514: IF FND_MSG_PUB.Check_Msg_Level
12515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12516: THEN
12517: FND_MSG_PUB.Add_Exc_Msg
12518: ( G_PKG_NAME
12519: , l_api_name
12520: );
12521: END IF;

Line 12523: FND_MSG_PUB.Count_And_Get

12519: , l_api_name
12520: );
12521: END IF;
12522:
12523: FND_MSG_PUB.Count_And_Get
12524: ( p_count => x_msg_count
12525: , p_data => x_msg_data
12526: );
12527:

Line 12602: FND_MSG_PUB.initialize;

12598: END IF;
12599:
12600: -- Initialize message list if p_init_msg_list is set to TRUE.
12601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12602: FND_MSG_PUB.initialize;
12603: END IF ;
12604:
12605:
12606: -- For Test/Debug

Line 13151: FND_MSG_PUB.Count_And_Get

13147:
13148: END IF;
13149:
13150: -- Standard call to get message count and if count is 1, get message info.
13151: FND_MSG_PUB.Count_And_Get
13152: ( p_count => x_msg_count
13153: , p_data => x_msg_data
13154: );
13155:

Line 13174: FND_MSG_PUB.Count_And_Get

13170: END IF;
13171:
13172: x_return_status := FND_API.G_RET_STS_ERROR ;
13173:
13174: FND_MSG_PUB.Count_And_Get
13175: ( p_count => x_msg_count
13176: , p_data => x_msg_data
13177: );
13178:

Line 13194: FND_MSG_PUB.Count_And_Get

13190: END IF;
13191:
13192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13193:
13194: FND_MSG_PUB.Count_And_Get
13195: ( p_count => x_msg_count
13196: , p_data => x_msg_data
13197: );
13198:

Line 13214: FND_MSG_PUB.Count_And_Get

13210: END IF;
13211:
13212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13213:
13214: FND_MSG_PUB.Count_And_Get
13215: ( p_count => x_msg_count
13216: , p_data => x_msg_data
13217: );
13218:

Line 13219: IF FND_MSG_PUB.Check_Msg_Level

13215: ( p_count => x_msg_count
13216: , p_data => x_msg_data
13217: );
13218:
13219: IF FND_MSG_PUB.Check_Msg_Level
13220: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13221: THEN
13222: FND_MSG_PUB.Add_Exc_Msg
13223: ( G_PKG_NAME

Line 13220: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

13216: , p_data => x_msg_data
13217: );
13218:
13219: IF FND_MSG_PUB.Check_Msg_Level
13220: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13221: THEN
13222: FND_MSG_PUB.Add_Exc_Msg
13223: ( G_PKG_NAME
13224: , l_api_name

Line 13222: FND_MSG_PUB.Add_Exc_Msg

13218:
13219: IF FND_MSG_PUB.Check_Msg_Level
13220: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13221: THEN
13222: FND_MSG_PUB.Add_Exc_Msg
13223: ( G_PKG_NAME
13224: , l_api_name
13225: );
13226: END IF;

Line 13228: FND_MSG_PUB.Count_And_Get

13224: , l_api_name
13225: );
13226: END IF;
13227:
13228: FND_MSG_PUB.Count_And_Get
13229: ( p_count => x_msg_count
13230: , p_data => x_msg_data
13231: );
13232:

Line 13699: FND_MSG_PUB.Count_And_Get

13695: WHEN FND_API.G_EXC_ERROR THEN
13696: ROLLBACK TO AbortWorkflow_Util ;
13697: x_return_status := FND_API.G_RET_STS_ERROR ;
13698:
13699: FND_MSG_PUB.Count_And_Get
13700: ( p_count => x_msg_count
13701: , p_data => x_msg_data
13702: );
13703: END reassignRoutePeople;

Line 13882: FND_MSG_PUB.initialize;

13878: END IF;
13879:
13880: -- Initialize message list if p_init_msg_list is set to TRUE.
13881: IF FND_API.to_Boolean( p_init_msg_list ) THEN
13882: FND_MSG_PUB.initialize;
13883: END IF ;
13884:
13885:
13886: -- For Test/Debug

Line 14265: FND_MSG_PUB.Count_And_Get

14261:
14262: END IF;
14263:
14264: -- Standard call to get message count and if count is 1, get message info.
14265: FND_MSG_PUB.Count_And_Get
14266: ( p_count => x_msg_count
14267: , p_data => x_msg_data
14268: );
14269:

Line 14286: FND_MSG_PUB.Count_And_Get

14282: ROLLBACK TO GrantObjectRoles ;
14283: END IF ;
14284: x_return_status := FND_API.G_RET_STS_ERROR ;
14285:
14286: FND_MSG_PUB.Count_And_Get
14287: ( p_count => x_msg_count
14288: , p_data => x_msg_data
14289: );
14290:

Line 14309: FND_MSG_PUB.Count_And_Get

14305: END IF ;
14306:
14307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14308:
14309: FND_MSG_PUB.Count_And_Get
14310: ( p_count => x_msg_count
14311: , p_data => x_msg_data
14312: );
14313:

Line 14332: FND_MSG_PUB.Count_And_Get

14328:
14329: END IF ;
14330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14331:
14332: FND_MSG_PUB.Count_And_Get
14333: ( p_count => x_msg_count
14334: , p_data => x_msg_data
14335: );
14336:

Line 14337: IF FND_MSG_PUB.Check_Msg_Level

14333: ( p_count => x_msg_count
14334: , p_data => x_msg_data
14335: );
14336:
14337: IF FND_MSG_PUB.Check_Msg_Level
14338: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14339: THEN
14340: FND_MSG_PUB.Add_Exc_Msg
14341: ( G_PKG_NAME

Line 14338: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

14334: , p_data => x_msg_data
14335: );
14336:
14337: IF FND_MSG_PUB.Check_Msg_Level
14338: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14339: THEN
14340: FND_MSG_PUB.Add_Exc_Msg
14341: ( G_PKG_NAME
14342: , l_api_name

Line 14340: FND_MSG_PUB.Add_Exc_Msg

14336:
14337: IF FND_MSG_PUB.Check_Msg_Level
14338: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14339: THEN
14340: FND_MSG_PUB.Add_Exc_Msg
14341: ( G_PKG_NAME
14342: , l_api_name
14343: );
14344: END IF;

Line 14346: FND_MSG_PUB.Count_And_Get

14342: , l_api_name
14343: );
14344: END IF;
14345:
14346: FND_MSG_PUB.Count_And_Get
14347: ( p_count => x_msg_count
14348: , p_data => x_msg_data
14349: );
14350:

Line 14839: FND_MSG_PUB.initialize;

14835: END IF;
14836:
14837: -- Initialize message list if p_init_msg_list is set to TRUE.
14838: IF FND_API.to_Boolean( p_init_msg_list ) THEN
14839: FND_MSG_PUB.initialize;
14840: END IF ;
14841:
14842:
14843: -- For Test/Debug

Line 15197: FND_MSG_PUB.Count_And_Get

15193:
15194: END IF;
15195:
15196: -- Standard call to get message count and if count is 1, get message info.
15197: FND_MSG_PUB.Count_And_Get
15198: ( p_count => x_msg_count
15199: , p_data => x_msg_data
15200: );
15201:

Line 15218: FND_MSG_PUB.Count_And_Get

15214: ROLLBACK TO RevokeObjectRoles ;
15215: END IF ;
15216: x_return_status := FND_API.G_RET_STS_ERROR ;
15217:
15218: FND_MSG_PUB.Count_And_Get
15219: ( p_count => x_msg_count
15220: , p_data => x_msg_data
15221: );
15222:

Line 15240: FND_MSG_PUB.Count_And_Get

15236: END IF ;
15237:
15238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15239:
15240: FND_MSG_PUB.Count_And_Get
15241: ( p_count => x_msg_count
15242: , p_data => x_msg_data
15243: );
15244:

Line 15262: FND_MSG_PUB.Count_And_Get

15258: END IF ;
15259:
15260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15261:
15262: FND_MSG_PUB.Count_And_Get
15263: ( p_count => x_msg_count
15264: , p_data => x_msg_data
15265: );
15266:

Line 15267: IF FND_MSG_PUB.Check_Msg_Level

15263: ( p_count => x_msg_count
15264: , p_data => x_msg_data
15265: );
15266:
15267: IF FND_MSG_PUB.Check_Msg_Level
15268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15269: THEN
15270: FND_MSG_PUB.Add_Exc_Msg
15271: ( G_PKG_NAME

Line 15268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

15264: , p_data => x_msg_data
15265: );
15266:
15267: IF FND_MSG_PUB.Check_Msg_Level
15268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15269: THEN
15270: FND_MSG_PUB.Add_Exc_Msg
15271: ( G_PKG_NAME
15272: , l_api_name

Line 15270: FND_MSG_PUB.Add_Exc_Msg

15266:
15267: IF FND_MSG_PUB.Check_Msg_Level
15268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15269: THEN
15270: FND_MSG_PUB.Add_Exc_Msg
15271: ( G_PKG_NAME
15272: , l_api_name
15273: );
15274: END IF;

Line 15276: FND_MSG_PUB.Count_And_Get

15272: , l_api_name
15273: );
15274: END IF;
15275:
15276: FND_MSG_PUB.Count_And_Get
15277: ( p_count => x_msg_count
15278: , p_data => x_msg_data
15279: );
15280: