DBA Data[Home] [Help]

APPS.INVKBCGN dependencies on FND_MSG_PUB

Line 206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

202: end if;
203:
204: Exception
205: when others then
206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
207: THEN
208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'Create_Kanban_Cards');
209: print_error;
210: END IF;

Line 208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'Create_Kanban_Cards');

204: Exception
205: when others then
206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
207: THEN
208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'Create_Kanban_Cards');
209: print_error;
210: END IF;
211: current_error_code := to_char(SQLCODE);
212: RETCODE := 2;

Line 297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

293: return v_success;
294:
295: Exception
296: when others then
297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_all_null');
300: print_error;
301: END IF;

Line 299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_all_null');

295: Exception
296: when others then
297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_all_null');
300: print_error;
301: END IF;
302: v_success := 2;
303: current_error_code := to_char(SQLCODE);

Line 379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

375: return v_success;
376:
377: Exception
378: when others then
379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_pull');
382: print_error;
383: END IF;

Line 381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_pull');

377: Exception
378: when others then
379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_pull');
382: print_error;
383: END IF;
384: v_success := 2;
385: current_error_code := to_char(SQLCODE);

Line 565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

561: end if;
562: end if;
563: Exception
564: when others then
565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
568: print_error;
569: END IF;

Line 567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');

563: Exception
564: when others then
565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
568: print_error;
569: END IF;
570: if dbms_sql.is_open(d_sql_p) then
571: dbms_sql.close_cursor(d_sql_p);

Line 714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

710: end if;
711: end if;
712: Exception
713: when others then
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
717: print_error;
718: END IF;

Line 716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');

712: Exception
713: when others then
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
717: print_error;
718: END IF;
719: if dbms_sql.is_open(d_sql_p) then
720: dbms_sql.close_cursor(d_sql_p);

Line 737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');

733: return v_success;
734:
735: Exception
736: when others then
737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
738: print_error;
739: v_success := 2;
740: current_error_code := to_char(SQLCODE);
741: return v_success;

Line 845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

841: end if;
842: current_error_code := to_char(SQLCODE);
843: Exception
844: when others then
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
848: print_error;
849: END IF;

Line 847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');

843: Exception
844: when others then
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
848: print_error;
849: END IF;
850: v_success := 2;
851: current_error_code := to_char(SQLCODE);

Line 977: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

973: end if;
974: end if;
975: Exception
976: when others then
977: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
980: print_error;
981: END IF;

Line 979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');

975: Exception
976: when others then
977: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
980: print_error;
981: END IF;
982: if dbms_sql.is_open(d_sql_p) then
983: dbms_sql.close_cursor(d_sql_p);

Line 1000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');

996: return v_success;
997:
998: Exception
999: when others then
1000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1001: print_error;
1002: v_success := 2;
1003: current_error_code := to_char(SQLCODE);
1004: return v_success;

Line 1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'card_check_and_create');

1118: print_error;
1119: when FND_API.G_EXC_UNEXPECTED_ERROR then
1120: print_error;
1121: when others then
1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'card_check_and_create');
1123: print_error;
1124: END card_check_and_create;
1125:
1126:

Line 1248: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'query_range_loc');

1244: current_error_code := to_char(SQLCODE);
1245: end if;
1246: Exception
1247: when others then
1248: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'query_range_loc');
1249: print_error;
1250: end query_range_loc;
1251:
1252:

Line 1341: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'query_range_itm');

1337: current_error_code := to_char(SQLCODE);
1338: end if;
1339: Exception
1340: when others then
1341: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'query_range_itm');
1342: print_error;
1343: end query_range_itm;
1344:
1345:

Line 1395: Fnd_msg_pub.Count_And_get(p_count => l_count,

1391: l_count number;
1392: l_msg varchar2(2000);
1393: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1394: begin
1395: Fnd_msg_pub.Count_And_get(p_count => l_count,
1396: p_data => l_msg,
1397: p_encoded => 'F');
1398: if l_count = 0
1399: then

Line 1407: l_msg := fnd_msg_pub.get(I,'F');

1403: PUT_LINE( l_msg);
1404: else
1405: For I in 1..l_count
1406: loop
1407: l_msg := fnd_msg_pub.get(I,'F');
1408: PUT_LINE( l_msg);
1409: end loop;
1410: PUT_LINE(' ');
1411: end if;

Line 1412: FND_MSG_PUB.initialize;

1408: PUT_LINE( l_msg);
1409: end loop;
1410: PUT_LINE(' ');
1411: end if;
1412: FND_MSG_PUB.initialize;
1413: Exception
1414: when others then
1415: PUT_LINE( SQLERRM );
1416: End Print_Error;