DBA Data[Home] [Help]

APPS.INVKBCGN dependencies on FND_MSG_PUB

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

224: end if;
225:
226: Exception
227: when others then
228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'Create_Kanban_Cards');
231: print_error;
232: END IF;

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

226: Exception
227: when others then
228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'Create_Kanban_Cards');
231: print_error;
232: END IF;
233: current_error_code := to_char(SQLCODE);
234: RETCODE := 2;

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

321: return v_success;
322:
323: Exception
324: when others then
325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_all_null');
328: print_error;
329: END IF;

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

323: Exception
324: when others then
325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_all_null');
328: print_error;
329: END IF;
330: v_success := 2;
331: current_error_code := to_char(SQLCODE);

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

408: return v_success;
409:
410: Exception
411: when others then
412: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_pull');
415: print_error;
416: END IF;

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

410: Exception
411: when others then
412: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_pull');
415: print_error;
416: END IF;
417: v_success := 2;
418: current_error_code := to_char(SQLCODE);

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

647: end if;
648: end if;
649: Exception
650: when others then
651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
652: THEN
653: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
654: print_error;
655: END IF;

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

649: Exception
650: when others then
651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
652: THEN
653: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
654: print_error;
655: END IF;
656: if dbms_sql.is_open(d_sql_p) then
657: dbms_sql.close_cursor(d_sql_p);

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

851: end if;
852: end if;
853: Exception
854: when others then
855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
858: print_error;
859: END IF;

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

853: Exception
854: when others then
855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
858: print_error;
859: END IF;
860: if dbms_sql.is_open(d_sql_p) then
861: dbms_sql.close_cursor(d_sql_p);

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

874: return v_success;
875:
876: Exception
877: when others then
878: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
879: print_error;
880: v_success := 2;
881: current_error_code := to_char(SQLCODE);
882: return v_success;

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

1051: end if;
1052: current_error_code := to_char(SQLCODE);
1053: Exception
1054: when others then
1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1058: print_error;
1059: END IF;

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

1053: Exception
1054: when others then
1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1058: print_error;
1059: END IF;
1060: v_success := 2;
1061: current_error_code := to_char(SQLCODE);

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

1230: end if;
1231: end if;
1232: Exception
1233: when others then
1234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1235: THEN
1236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1237: print_error;
1238: END IF;

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

1232: Exception
1233: when others then
1234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1235: THEN
1236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1237: print_error;
1238: END IF;
1239: if dbms_sql.is_open(d_sql_p) then
1240: dbms_sql.close_cursor(d_sql_p);

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

1253: return v_success;
1254:
1255: Exception
1256: when others then
1257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1258: print_error;
1259: v_success := 2;
1260: current_error_code := to_char(SQLCODE);
1261: return v_success;

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

1545: print_error;
1546: when FND_API.G_EXC_UNEXPECTED_ERROR then
1547: print_error;
1548: when others then
1549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'card_check_and_create');
1550: print_error;
1551: END card_check_and_create;
1552:
1553: PROCEDURE query_range_loc( X_org_id IN Number,

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

1670: current_error_code := to_char(SQLCODE);
1671: end if;
1672: Exception
1673: when others then
1674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'query_range_loc');
1675: print_error;
1676: end query_range_loc;
1677:
1678:

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

1763: current_error_code := to_char(SQLCODE);
1764: end if;
1765: Exception
1766: when others then
1767: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'query_range_itm');
1768: print_error;
1769: end query_range_itm;
1770:
1771:

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

1844: l_count number;
1845: l_msg varchar2(2000);
1846: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1847: begin
1848: Fnd_msg_pub.Count_And_get(p_count => l_count,
1849: p_data => l_msg,
1850: p_encoded => 'F');
1851: if l_count = 0
1852: then

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

1856: PUT_LINE( l_msg);
1857: else
1858: For I in 1..l_count
1859: loop
1860: l_msg := fnd_msg_pub.get(I,'F');
1861: PUT_LINE( l_msg);
1862: end loop;
1863: PUT_LINE(' ');
1864: end if;

Line 1865: FND_MSG_PUB.initialize;

1861: PUT_LINE( l_msg);
1862: end loop;
1863: PUT_LINE(' ');
1864: end if;
1865: FND_MSG_PUB.initialize;
1866: Exception
1867: when others then
1868: PUT_LINE( SQLERRM );
1869: End Print_Error;