eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on FND_MSG_PUB

Line 379: fnd_msg_pub.add;

375: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
376: ELSE
377: fnd_message.set_name('CSD','CSD_UOM_MISSING');
378: fnd_message.set_token('UOM',p_from_uom);
379: fnd_msg_pub.add;
380: END IF;
381: RAISE FND_API.G_EXC_ERROR;
382: WHEN TOO_MANY_ROWS THEN
383: IF ( l_error_level >= G_debug_level) THEN

Line 390: fnd_msg_pub.add;

386: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
387: ELSE
388: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
389: fnd_message.set_token('UOM',p_from_uom);
390: fnd_msg_pub.add;
391: END IF;
392: RAISE FND_API.G_EXC_ERROR;
393: End;
394: Else

Line 420: fnd_msg_pub.add;

416: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
417: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
418: ELSE
419: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
420: fnd_msg_pub.add;
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424: ELSE

Line 511: FND_MSG_PUB.initialize;

507: END IF;
508:
509: -- Initialize message list if p_init_msg_list is set to TRUE.
510: IF FND_API.to_Boolean( p_init_msg_list ) THEN
511: FND_MSG_PUB.initialize;
512: END IF;
513:
514: -- Debug messages
515: Debug('p_EVENT_CODE ='||p_activity_rec.EVENT_CODE,l_mod_name,1);

Line 619: FND_MSG_PUB.Count_And_Get

615: COMMIT WORK;
616: END IF;
617:
618: -- Standard call to get message count and IF count is get message info.
619: FND_MSG_PUB.Count_And_Get
620: (p_count => x_msg_count,
621: p_data => x_msg_data );
622: EXCEPTION
623: WHEN FND_API.G_EXC_ERROR THEN

Line 627: FND_MSG_PUB.Count_And_Get

623: WHEN FND_API.G_EXC_ERROR THEN
624: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
625: ROLLBACK TO LOG_ACTIVITY;
626: x_return_status := FND_API.G_RET_STS_ERROR ;
627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,
629: p_data => x_msg_data );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

Line 634: FND_MSG_PUB.Count_And_Get

630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
632: ROLLBACK TO LOG_ACTIVITY;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
634: FND_MSG_PUB.Count_And_Get
635: ( p_count => x_msg_count,
636: p_data => x_msg_data );
637: WHEN OTHERS THEN
638: Debug('In OTHERS exception',l_mod_name,4 );

Line 641: IF FND_MSG_PUB.Check_Msg_Level

637: WHEN OTHERS THEN
638: Debug('In OTHERS exception',l_mod_name,4 );
639: ROLLBACK TO LOG_ACTIVITY;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: (G_PKG_NAME ,

Line 642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

638: Debug('In OTHERS exception',l_mod_name,4 );
639: ROLLBACK TO LOG_ACTIVITY;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: (G_PKG_NAME ,
646: l_api_name );

Line 644: FND_MSG_PUB.Add_Exc_Msg

640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: (G_PKG_NAME ,
646: l_api_name );
647: END IF;
648: FND_MSG_PUB.Count_And_Get

Line 648: FND_MSG_PUB.Count_And_Get

644: FND_MSG_PUB.Add_Exc_Msg
645: (G_PKG_NAME ,
646: l_api_name );
647: END IF;
648: FND_MSG_PUB.Count_And_Get
649: (p_count => x_msg_count,
650: p_data => x_msg_data );
651: END LOG_ACTIVITY;
652:

Line 832: FND_MSG_PUB.initialize;

828: END IF;
829:
830: -- Initialize message list if p_init_msg_list is set to TRUE.
831: IF FND_API.to_Boolean( p_init_msg_list ) THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834:
835: -- Keep the record count
836: l_count := 0;

Line 971: FND_MSG_PUB.ADD;

967: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
968: ELSE
969: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
970: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
971: FND_MSG_PUB.ADD;
972: END IF;
973: RAISE FND_API.G_EXC_ERROR;
974: End IF;
975:

Line 1094: FND_MSG_PUB.ADD;

1090: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1091: ELSE
1092: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1093: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1094: FND_MSG_PUB.ADD;
1095: END IF;
1096: RAISE FND_API.G_EXC_ERROR;
1097: End IF;
1098:

Line 1226: FND_MSG_PUB.ADD;

1222: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1223: ELSE
1224: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1225: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1226: FND_MSG_PUB.ADD;
1227: END IF;
1228: RAISE FND_API.G_EXC_ERROR;
1229: End IF;
1230:

Line 1279: FND_MSG_PUB.ADD;

1275: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1276: ELSE
1277: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1278: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1279: FND_MSG_PUB.ADD;
1280: END IF;
1281: RAISE FND_API.G_EXC_ERROR;
1282: END;
1283: END IF;

Line 1343: FND_MSG_PUB.ADD;

1339: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1340: ELSE
1341: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1342: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1343: FND_MSG_PUB.ADD;
1344: END IF;
1345: RAISE FND_API.G_EXC_ERROR;
1346: End IF;
1347:

Line 1442: FND_MSG_PUB.ADD;

1438:
1439: -- Log messages for the number of records processed
1440: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1441: fnd_message.set_token('TOT_REC',to_char(l_total_rec));
1442: FND_MSG_PUB.ADD;
1443:
1444: -- Retrive the message from the msg stack
1445: l_msg_text := fnd_message.get;
1446:

Line 1460: FND_MSG_PUB.Count_And_Get

1456: COMMIT WORK;
1457: END IF;
1458:
1459: -- Standard call to get message count and IF count is get message info.
1460: FND_MSG_PUB.Count_And_Get
1461: (p_count => x_msg_count,
1462: p_data => x_msg_data );
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN

Line 1468: FND_MSG_PUB.Count_And_Get

1464: WHEN FND_API.G_EXC_ERROR THEN
1465: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1466: ROLLBACK TO JOB_COMPLETION_UPDATE;
1467: x_return_status := FND_API.G_RET_STS_ERROR ;
1468: FND_MSG_PUB.Count_And_Get
1469: (p_count => x_msg_count,
1470: p_data => x_msg_data );
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

Line 1475: FND_MSG_PUB.Count_And_Get

1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1473: ROLLBACK TO JOB_COMPLETION_UPDATE;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1475: FND_MSG_PUB.Count_And_Get
1476: ( p_count => x_msg_count,
1477: p_data => x_msg_data );
1478: WHEN OTHERS THEN
1479: Debug('In OTHERS exception',l_mod_name,4);

Line 1482: IF FND_MSG_PUB.Check_Msg_Level

1478: WHEN OTHERS THEN
1479: Debug('In OTHERS exception',l_mod_name,4);
1480: ROLLBACK TO JOB_COMPLETION_UPDATE;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: IF FND_MSG_PUB.Check_Msg_Level
1483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1484: THEN
1485: FND_MSG_PUB.Add_Exc_Msg
1486: (G_PKG_NAME ,

Line 1483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1479: Debug('In OTHERS exception',l_mod_name,4);
1480: ROLLBACK TO JOB_COMPLETION_UPDATE;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: IF FND_MSG_PUB.Check_Msg_Level
1483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1484: THEN
1485: FND_MSG_PUB.Add_Exc_Msg
1486: (G_PKG_NAME ,
1487: l_api_name );

Line 1485: FND_MSG_PUB.Add_Exc_Msg

1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: IF FND_MSG_PUB.Check_Msg_Level
1483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1484: THEN
1485: FND_MSG_PUB.Add_Exc_Msg
1486: (G_PKG_NAME ,
1487: l_api_name );
1488: END IF;
1489: FND_MSG_PUB.Count_And_Get

Line 1489: FND_MSG_PUB.Count_And_Get

1485: FND_MSG_PUB.Add_Exc_Msg
1486: (G_PKG_NAME ,
1487: l_api_name );
1488: END IF;
1489: FND_MSG_PUB.Count_And_Get
1490: (p_count => x_msg_count,
1491: p_data => x_msg_data );
1492: END JOB_COMPLETION_UPDATE;
1493:

Line 1614: FND_MSG_PUB.initialize;

1610: END IF;
1611:
1612: -- Initialize message list if p_init_msg_list is set to TRUE.
1613: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1614: FND_MSG_PUB.initialize;
1615: END IF;
1616:
1617: -- Keeping the running total of the records
1618: -- for commiting purpose

Line 1718: FND_MSG_PUB.ADD;

1714: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1715: ELSE
1716: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1717: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1718: FND_MSG_PUB.ADD;
1719: END IF;
1720: RAISE FND_API.G_EXC_ERROR;
1721: End IF;
1722:

Line 1739: FND_MSG_PUB.ADD;

1735: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1736: ELSE
1737: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1738: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1739: FND_MSG_PUB.ADD;
1740: END IF;
1741: RAISE FND_API.G_EXC_ERROR;
1742: End IF;
1743:

Line 1785: FND_MSG_PUB.Count_And_Get

1781: COMMIT WORK;
1782: END IF;
1783:
1784: -- Standard call to get message count and IF count is get message info.
1785: FND_MSG_PUB.Count_And_Get
1786: (p_count => x_msg_count,
1787: p_data => x_msg_data );
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN

Line 1793: FND_MSG_PUB.Count_And_Get

1789: WHEN FND_API.G_EXC_ERROR THEN
1790: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1791: ROLLBACK TO JOB_CREATION_UPDATE;
1792: x_return_status := FND_API.G_RET_STS_ERROR ;
1793: FND_MSG_PUB.Count_And_Get
1794: (p_count => x_msg_count,
1795: p_data => x_msg_data );
1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1797: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

Line 1800: FND_MSG_PUB.Count_And_Get

1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1797: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1798: ROLLBACK TO JOB_CREATION_UPDATE;
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1800: FND_MSG_PUB.Count_And_Get
1801: ( p_count => x_msg_count,
1802: p_data => x_msg_data );
1803: WHEN OTHERS THEN
1804: Debug('In OTHERS exception',l_mod_name,4);

Line 1807: IF FND_MSG_PUB.Check_Msg_Level

1803: WHEN OTHERS THEN
1804: Debug('In OTHERS exception',l_mod_name,4);
1805: ROLLBACK TO JOB_CREATION_UPDATE;
1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1807: IF FND_MSG_PUB.Check_Msg_Level
1808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1809: THEN
1810: FND_MSG_PUB.Add_Exc_Msg
1811: (G_PKG_NAME ,

Line 1808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1804: Debug('In OTHERS exception',l_mod_name,4);
1805: ROLLBACK TO JOB_CREATION_UPDATE;
1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1807: IF FND_MSG_PUB.Check_Msg_Level
1808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1809: THEN
1810: FND_MSG_PUB.Add_Exc_Msg
1811: (G_PKG_NAME ,
1812: l_api_name );

Line 1810: FND_MSG_PUB.Add_Exc_Msg

1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1807: IF FND_MSG_PUB.Check_Msg_Level
1808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1809: THEN
1810: FND_MSG_PUB.Add_Exc_Msg
1811: (G_PKG_NAME ,
1812: l_api_name );
1813: END IF;
1814: FND_MSG_PUB.Count_And_Get

Line 1814: FND_MSG_PUB.Count_And_Get

1810: FND_MSG_PUB.Add_Exc_Msg
1811: (G_PKG_NAME ,
1812: l_api_name );
1813: END IF;
1814: FND_MSG_PUB.Count_And_Get
1815: (p_count => x_msg_count,
1816: p_data => x_msg_data );
1817: END JOB_CREATION_UPDATE;
1818:

Line 1893: FND_MSG_PUB.initialize;

1889: END IF;
1890:
1891: -- Initialize message list if p_init_msg_list is set to TRUE.
1892: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1893: FND_MSG_PUB.initialize;
1894: END IF;
1895:
1896: -- Api body starts
1897: IF p_internal_order_flag = 'Y' then

Line 1981: FND_MSG_PUB.Count_And_Get

1977: COMMIT WORK;
1978: END IF;
1979:
1980: -- Standard call to get message count and IF count is get message info.
1981: FND_MSG_PUB.Count_And_Get
1982: (p_count => x_msg_count,
1983: p_data => x_msg_data );
1984: EXCEPTION
1985: WHEN FND_API.G_EXC_ERROR THEN

Line 1993: FND_MSG_PUB.Count_And_Get

1989: IF NOT(FND_API.To_Boolean( p_commit )) THEN
1990: ROLLBACK TO RECEIPTS_UPDATE;
1991: END IF;
1992: x_return_status := FND_API.G_RET_STS_ERROR ;
1993: FND_MSG_PUB.Count_And_Get
1994: (p_count => x_msg_count,
1995: p_data => x_msg_data );
1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1997: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );

Line 2010: FND_MSG_PUB.Count_And_Get

2006: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2007: ROLLBACK TO RECEIPTS_UPDATE;
2008: END IF;
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2010: FND_MSG_PUB.Count_And_Get
2011: ( p_count => x_msg_count,
2012: p_data => x_msg_data );
2013: WHEN OTHERS THEN
2014: Debug('In OTHERS exception',l_mod_name,4 );

Line 2027: IF FND_MSG_PUB.Check_Msg_Level

2023: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2024: ROLLBACK TO RECEIPTS_UPDATE;
2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2027: IF FND_MSG_PUB.Check_Msg_Level
2028: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2029: THEN
2030: FND_MSG_PUB.Add_Exc_Msg
2031: (G_PKG_NAME ,

Line 2028: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2024: ROLLBACK TO RECEIPTS_UPDATE;
2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2027: IF FND_MSG_PUB.Check_Msg_Level
2028: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2029: THEN
2030: FND_MSG_PUB.Add_Exc_Msg
2031: (G_PKG_NAME ,
2032: l_api_name );

Line 2030: FND_MSG_PUB.Add_Exc_Msg

2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2027: IF FND_MSG_PUB.Check_Msg_Level
2028: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2029: THEN
2030: FND_MSG_PUB.Add_Exc_Msg
2031: (G_PKG_NAME ,
2032: l_api_name );
2033: END IF;
2034: FND_MSG_PUB.Count_And_Get

Line 2034: FND_MSG_PUB.Count_And_Get

2030: FND_MSG_PUB.Add_Exc_Msg
2031: (G_PKG_NAME ,
2032: l_api_name );
2033: END IF;
2034: FND_MSG_PUB.Count_And_Get
2035: (p_count => x_msg_count,
2036: p_data => x_msg_data );
2037: END RECEIPTS_UPDATE;
2038:

Line 2386: FND_MSG_PUB.initialize;

2382: END IF;
2383:
2384: -- Initialize message list if p_init_msg_list is set to TRUE.
2385: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2386: FND_MSG_PUB.initialize;
2387: END IF;
2388:
2389: -- Api body starts
2390:

Line 2610: fnd_msg_pub.add;

2606: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2607: ELSE
2608: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2609: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2610: fnd_msg_pub.add;
2611: END IF;
2612: RAISE FND_API.G_EXC_ERROR;
2613: When others then
2614: Debug('In Others exception',l_mod_name,4);

Line 2637: FND_MSG_PUB.ADD;

2633: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2634: ELSE
2635: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2636: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2637: FND_MSG_PUB.ADD;
2638: END IF;
2639: RAISE FND_API.G_EXC_ERROR;
2640: END IF;
2641: -- Close the cursor

Line 2668: FND_MSG_PUB.ADD;

2664: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2665: ELSE
2666: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2667: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2668: FND_MSG_PUB.ADD;
2669: END IF;
2670: RAISE FND_API.G_EXC_ERROR;
2671: Debug(' Could not find any IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
2672: WHEN TOO_MANY_ROWS THEN

Line 2680: FND_MSG_PUB.ADD;

2676: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2677: ELSE
2678: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2679: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2680: FND_MSG_PUB.ADD;
2681: END IF;
2682: RAISE FND_API.G_EXC_ERROR;
2683: Debug(' Found many IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
2684: END;

Line 2764: fnd_msg_pub.add;

2760: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2761: ELSE
2762: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2763: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2764: fnd_msg_pub.add;
2765: END IF;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END;
2768: ELSE

Line 2824: fnd_msg_pub.add;

2820: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2821: ELSE
2822: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2823: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2824: fnd_msg_pub.add;
2825: END IF;
2826: RAISE FND_API.G_EXC_ERROR;
2827: END IF;
2828:

Line 2847: fnd_msg_pub.add;

2843: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2844: ELSE
2845: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2846: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2847: fnd_msg_pub.add;
2848: END IF;
2849: RAISE FND_API.G_EXC_ERROR;
2850: END IF;
2851:

Line 2883: fnd_msg_pub.add;

2879: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2880: ELSE
2881: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2882: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2883: fnd_msg_pub.add;
2884: END IF;
2885: RAISE FND_API.G_EXC_ERROR;
2886: END IF;
2887:

Line 2892: FND_MSG_PUB.ADD;

2888: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2889: fnd_message.set_token('RMA_NO',i.rma_number);
2890: fnd_message.set_token('REP_NO',i.repair_number);
2891: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2892: FND_MSG_PUB.ADD;
2893:
2894: -- Debug message
2895: Debug(fnd_message.get,l_mod_name,1);
2896:

Line 2997: FND_MSG_PUB.ADD;

2993: -- Log seed messages for the number of records
2994: -- processed by rma update
2995: fnd_message.set_name('CSD','CSD_DRC_RMA_TOT_REC_PROC');
2996: fnd_message.set_token('TOT_REC',to_char(l_total_records));
2997: FND_MSG_PUB.ADD;
2998:
2999: -- Debug Messages
3000: Debug(fnd_message.get,l_mod_name,1);
3001:

Line 3013: FND_MSG_PUB.Count_And_Get

3009: COMMIT WORK;
3010: END IF;
3011:
3012: -- Standard call to get message count and IF count is get message info.
3013: FND_MSG_PUB.Count_And_Get
3014: (p_count => x_msg_count,
3015: p_data => x_msg_data );
3016: EXCEPTION
3017: WHEN FND_API.G_EXC_ERROR THEN

Line 3021: FND_MSG_PUB.Count_And_Get

3017: WHEN FND_API.G_EXC_ERROR THEN
3018: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
3019: ROLLBACK TO RMA_RCV_UPDATE;
3020: x_return_status := FND_API.G_RET_STS_ERROR ;
3021: FND_MSG_PUB.Count_And_Get
3022: (p_count => x_msg_count,
3023: p_data => x_msg_data );
3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3025: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );

Line 3028: FND_MSG_PUB.Count_And_Get

3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3025: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
3026: ROLLBACK TO RMA_RCV_UPDATE;
3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3028: FND_MSG_PUB.Count_And_Get
3029: ( p_count => x_msg_count,
3030: p_data => x_msg_data );
3031: WHEN OTHERS THEN
3032: Debug('In OTHERS exception',l_mod_name,4 );

Line 3035: IF FND_MSG_PUB.Check_Msg_Level

3031: WHEN OTHERS THEN
3032: Debug('In OTHERS exception',l_mod_name,4 );
3033: ROLLBACK TO RMA_RCV_UPDATE;
3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3035: IF FND_MSG_PUB.Check_Msg_Level
3036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3037: THEN
3038: FND_MSG_PUB.Add_Exc_Msg
3039: (G_PKG_NAME ,

Line 3036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3032: Debug('In OTHERS exception',l_mod_name,4 );
3033: ROLLBACK TO RMA_RCV_UPDATE;
3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3035: IF FND_MSG_PUB.Check_Msg_Level
3036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3037: THEN
3038: FND_MSG_PUB.Add_Exc_Msg
3039: (G_PKG_NAME ,
3040: l_api_name );

Line 3038: FND_MSG_PUB.Add_Exc_Msg

3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3035: IF FND_MSG_PUB.Check_Msg_Level
3036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3037: THEN
3038: FND_MSG_PUB.Add_Exc_Msg
3039: (G_PKG_NAME ,
3040: l_api_name );
3041: END IF;
3042: FND_MSG_PUB.Count_And_Get

Line 3042: FND_MSG_PUB.Count_And_Get

3038: FND_MSG_PUB.Add_Exc_Msg
3039: (G_PKG_NAME ,
3040: l_api_name );
3041: END IF;
3042: FND_MSG_PUB.Count_And_Get
3043: (p_count => x_msg_count,
3044: p_data => x_msg_data );
3045: END RMA_RCV_UPDATE;
3046:

Line 3280: FND_MSG_PUB.initialize;

3276: END IF;
3277:
3278: -- Initialize message list if p_init_msg_list is set to TRUE.
3279: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3280: FND_MSG_PUB.initialize;
3281: END IF;
3282:
3283: -- Api body starts
3284:

Line 3310: fnd_msg_pub.add;

3306: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3307: ELSE
3308: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3309: fnd_message.set_token('HEADER_ID',p_order_header_id);
3310: fnd_msg_pub.add;
3311: END IF;
3312: RAISE FND_API.G_EXC_ERROR;
3313: END;
3314: END IF;

Line 3539: fnd_msg_pub.add;

3535: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3536: ELSE
3537: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3538: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3539: fnd_msg_pub.add;
3540: END If;
3541: RAISE PROCESS_ERROR;
3542: END;
3543: -- Get the instance id from

Line 3561: fnd_msg_pub.add;

3557: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3558: ELSE
3559: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3560: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3561: fnd_msg_pub.add;
3562: END If;
3563: When Others THEN
3564: IF ( l_error_level >= G_debug_level) THEN
3565: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

Line 3571: fnd_msg_pub.add;

3567: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3568: ELSE
3569: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3570: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3571: fnd_msg_pub.add;
3572: END If;
3573: End;
3574: ELSE
3575: l_instance_id := NULL;

Line 3602: fnd_msg_pub.add;

3598: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3599: ELSE
3600: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3601: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3602: fnd_msg_pub.add;
3603: END IF;
3604: RAISE FND_API.G_EXC_ERROR;
3605: END;
3606: ELSE

Line 3650: fnd_msg_pub.add;

3646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3647: ELSE
3648: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3649: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3650: fnd_msg_pub.add;
3651: END IF;
3652: RAISE PROCESS_ERROR;
3653: END IF;
3654:

Line 3679: fnd_msg_pub.add;

3675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3676: ELSE
3677: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3678: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3679: fnd_msg_pub.add;
3680: END IF;
3681: RAISE PROCESS_ERROR;
3682: END IF;
3683:

Line 3907: fnd_msg_pub.add;

3903: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3904: ELSE
3905: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3906: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3907: fnd_msg_pub.add;
3908: END If;
3909: RAISE PROCESS_ERROR;
3910: END;
3911: -- Get the instance id from

Line 3929: fnd_msg_pub.add;

3925: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3926: ELSE
3927: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3928: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3929: fnd_msg_pub.add;
3930: END If;
3931: When Others THEN
3932: IF ( l_error_level >= G_debug_level) THEN
3933: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

Line 3939: fnd_msg_pub.add;

3935: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3936: ELSE
3937: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3938: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3939: fnd_msg_pub.add;
3940: END If;
3941: End;
3942: ELSE
3943: l_instance_id := NULL;

Line 3970: fnd_msg_pub.add;

3966: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3967: ELSE
3968: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3969: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3970: fnd_msg_pub.add;
3971: END IF;
3972: RAISE FND_API.G_EXC_ERROR;
3973: END;
3974: ELSE

Line 4018: fnd_msg_pub.add;

4014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4015: ELSE
4016: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4017: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4018: fnd_msg_pub.add;
4019: END IF;
4020: RAISE PROCESS_ERROR;
4021: END IF;
4022:

Line 4048: fnd_msg_pub.add;

4044: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4045: ELSE
4046: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4047: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4048: fnd_msg_pub.add;
4049: END IF;
4050: RAISE PROCESS_ERROR;
4051: END IF;
4052:

Line 4183: fnd_msg_pub.add;

4179: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4180: ELSE
4181: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4182: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4183: fnd_msg_pub.add;
4184: END IF;
4185: RAISE PROCESS_ERROR;
4186: END;
4187:

Line 4206: fnd_msg_pub.add;

4202: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4203: ELSE
4204: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4205: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4206: fnd_msg_pub.add;
4207: END If;
4208: When Others THEN
4209: IF ( l_error_level >= G_debug_level) THEN
4210: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

Line 4216: fnd_msg_pub.add;

4212: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4213: ELSE
4214: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4215: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4216: fnd_msg_pub.add;
4217: END If;
4218: End;
4219: ELSE
4220: l_instance_id := NULL;

Line 4245: fnd_msg_pub.add;

4241: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4242: ELSE
4243: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4244: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4245: fnd_msg_pub.add;
4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;
4248: END;
4249: ELSE

Line 4293: fnd_msg_pub.add;

4289: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4290: ELSE
4291: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4292: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4293: fnd_msg_pub.add;
4294: END IF;
4295: RAISE PROCESS_ERROR;
4296: END IF;
4297:

Line 4321: fnd_msg_pub.add;

4317: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4318: ELSE
4319: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4320: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4321: fnd_msg_pub.add;
4322: END IF;
4323: RAISE PROCESS_ERROR;
4324: END IF;
4325:

Line 4426: FND_MSG_PUB.Count_And_Get

4422: COMMIT WORK;
4423: END IF;
4424:
4425: -- Standard call to get message count and IF count is get message info.
4426: FND_MSG_PUB.Count_And_Get
4427: (p_count => x_msg_count,
4428: p_data => x_msg_data);
4429: EXCEPTION
4430: WHEN FND_API.G_EXC_ERROR THEN

Line 4434: FND_MSG_PUB.Count_And_Get

4430: WHEN FND_API.G_EXC_ERROR THEN
4431: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
4432: ROLLBACK TO IO_RCV_UPDATE;
4433: x_return_status := FND_API.G_RET_STS_ERROR ;
4434: FND_MSG_PUB.Count_And_Get
4435: (p_count => x_msg_count,
4436: p_data => x_msg_data );
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

Line 4441: FND_MSG_PUB.Count_And_Get

4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
4439: ROLLBACK TO IO_RCV_UPDATE;
4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4441: FND_MSG_PUB.Count_And_Get
4442: ( p_count => x_msg_count,
4443: p_data => x_msg_data );
4444: WHEN OTHERS THEN
4445: Debug('In OTHERS exception',l_mod_name,4);

Line 4448: IF FND_MSG_PUB.Check_Msg_Level

4444: WHEN OTHERS THEN
4445: Debug('In OTHERS exception',l_mod_name,4);
4446: ROLLBACK TO IO_RCV_UPDATE;
4447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4448: IF FND_MSG_PUB.Check_Msg_Level
4449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4450: THEN
4451: FND_MSG_PUB.Add_Exc_Msg
4452: (G_PKG_NAME ,

Line 4449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4445: Debug('In OTHERS exception',l_mod_name,4);
4446: ROLLBACK TO IO_RCV_UPDATE;
4447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4448: IF FND_MSG_PUB.Check_Msg_Level
4449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4450: THEN
4451: FND_MSG_PUB.Add_Exc_Msg
4452: (G_PKG_NAME ,
4453: l_api_name );

Line 4451: FND_MSG_PUB.Add_Exc_Msg

4447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4448: IF FND_MSG_PUB.Check_Msg_Level
4449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4450: THEN
4451: FND_MSG_PUB.Add_Exc_Msg
4452: (G_PKG_NAME ,
4453: l_api_name );
4454: END IF;
4455: FND_MSG_PUB.Count_And_Get

Line 4455: FND_MSG_PUB.Count_And_Get

4451: FND_MSG_PUB.Add_Exc_Msg
4452: (G_PKG_NAME ,
4453: l_api_name );
4454: END IF;
4455: FND_MSG_PUB.Count_And_Get
4456: (p_count => x_msg_count,
4457: p_data => x_msg_data );
4458: END IO_RCV_UPDATE;
4459:

Line 4696: FND_MSG_PUB.initialize;

4692: END IF;
4693:
4694: -- Initialize message list if p_init_msg_list is set to TRUE.
4695: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4696: FND_MSG_PUB.initialize;
4697: END IF;
4698:
4699: -- Api body starts
4700:

Line 4726: fnd_msg_pub.add;

4722: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4723: ELSE
4724: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4725: fnd_message.set_token('HEADER_ID',p_order_header_id);
4726: fnd_msg_pub.add;
4727: END IF;
4728: RAISE FND_API.G_EXC_ERROR;
4729: END;
4730: END IF;

Line 4955: fnd_msg_pub.add;

4951: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4952: ELSE
4953: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4954: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4955: fnd_msg_pub.add;
4956: END If;
4957: RAISE PROCESS_ERROR;
4958: END;
4959: -- Get the instance id from

Line 4977: fnd_msg_pub.add;

4973: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4974: ELSE
4975: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4976: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4977: fnd_msg_pub.add;
4978: END If;
4979: When Others THEN
4980: IF ( l_error_level >= G_debug_level) THEN
4981: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

Line 4987: fnd_msg_pub.add;

4983: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4984: ELSE
4985: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4986: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4987: fnd_msg_pub.add;
4988: END If;
4989: End;
4990: ELSE
4991: l_instance_id := NULL;

Line 5018: fnd_msg_pub.add;

5014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5015: ELSE
5016: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5017: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5018: fnd_msg_pub.add;
5019: END IF;
5020: RAISE FND_API.G_EXC_ERROR;
5021: END;
5022: ELSE

Line 5071: fnd_msg_pub.add;

5067: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5068: ELSE
5069: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5070: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5071: fnd_msg_pub.add;
5072: END IF;
5073: RAISE PROCESS_ERROR;
5074: END IF;
5075: */

Line 5100: fnd_msg_pub.add;

5096: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5097: ELSE
5098: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5099: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5100: fnd_msg_pub.add;
5101: END IF;
5102: RAISE PROCESS_ERROR;
5103: END IF;
5104:

Line 5328: fnd_msg_pub.add;

5324: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5325: ELSE
5326: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5327: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5328: fnd_msg_pub.add;
5329: END If;
5330: RAISE PROCESS_ERROR;
5331: END;
5332: -- Get the instance id from

Line 5350: fnd_msg_pub.add;

5346: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5347: ELSE
5348: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5349: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5350: fnd_msg_pub.add;
5351: END If;
5352: When Others THEN
5353: IF ( l_error_level >= G_debug_level) THEN
5354: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

Line 5360: fnd_msg_pub.add;

5356: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5357: ELSE
5358: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5359: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5360: fnd_msg_pub.add;
5361: END If;
5362: End;
5363: ELSE
5364: l_instance_id := NULL;

Line 5391: fnd_msg_pub.add;

5387: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5388: ELSE
5389: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5390: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5391: fnd_msg_pub.add;
5392: END IF;
5393: RAISE FND_API.G_EXC_ERROR;
5394: END;
5395: ELSE

Line 5444: fnd_msg_pub.add;

5440: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5441: ELSE
5442: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5443: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5444: fnd_msg_pub.add;
5445: END IF;
5446: RAISE PROCESS_ERROR;
5447: END IF;
5448: */

Line 5474: fnd_msg_pub.add;

5470: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5471: ELSE
5472: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5473: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5474: fnd_msg_pub.add;
5475: END IF;
5476: RAISE PROCESS_ERROR;
5477: END IF;
5478:

Line 5617: fnd_msg_pub.add;

5613: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5614: ELSE
5615: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5616: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5617: fnd_msg_pub.add;
5618: END IF;
5619: RAISE PROCESS_ERROR;
5620: END;
5621:

Line 5640: fnd_msg_pub.add;

5636: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5637: ELSE
5638: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5639: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5640: fnd_msg_pub.add;
5641: END If;
5642: When Others THEN
5643: IF ( l_error_level >= G_debug_level) THEN
5644: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

Line 5650: fnd_msg_pub.add;

5646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5647: ELSE
5648: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5649: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5650: fnd_msg_pub.add;
5651: END If;
5652: End;
5653: ELSE
5654: l_instance_id := NULL;

Line 5679: fnd_msg_pub.add;

5675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5676: ELSE
5677: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5678: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5679: fnd_msg_pub.add;
5680: END IF;
5681: RAISE FND_API.G_EXC_ERROR;
5682: END;
5683: ELSE

Line 5732: fnd_msg_pub.add;

5728: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5729: ELSE
5730: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5731: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5732: fnd_msg_pub.add;
5733: END IF;
5734: RAISE PROCESS_ERROR;
5735: END IF;
5736: */

Line 5760: fnd_msg_pub.add;

5756: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5757: ELSE
5758: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5759: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5760: fnd_msg_pub.add;
5761: END IF;
5762: RAISE PROCESS_ERROR;
5763: END IF;
5764:

Line 5865: FND_MSG_PUB.Count_And_Get

5861: COMMIT WORK;
5862: END IF;
5863:
5864: -- Standard call to get message count and IF count is get message info.
5865: FND_MSG_PUB.Count_And_Get
5866: (p_count => x_msg_count,
5867: p_data => x_msg_data);
5868: EXCEPTION
5869: WHEN FND_API.G_EXC_ERROR THEN

Line 5873: FND_MSG_PUB.Count_And_Get

5869: WHEN FND_API.G_EXC_ERROR THEN
5870: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
5871: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5872: x_return_status := FND_API.G_RET_STS_ERROR ;
5873: FND_MSG_PUB.Count_And_Get
5874: (p_count => x_msg_count,
5875: p_data => x_msg_data );
5876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5877: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

Line 5880: FND_MSG_PUB.Count_And_Get

5876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5877: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
5878: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5880: FND_MSG_PUB.Count_And_Get
5881: ( p_count => x_msg_count,
5882: p_data => x_msg_data );
5883: WHEN OTHERS THEN
5884: Debug('In OTHERS exception',l_mod_name,4);

Line 5887: IF FND_MSG_PUB.Check_Msg_Level

5883: WHEN OTHERS THEN
5884: Debug('In OTHERS exception',l_mod_name,4);
5885: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5887: IF FND_MSG_PUB.Check_Msg_Level
5888: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5889: THEN
5890: FND_MSG_PUB.Add_Exc_Msg
5891: (G_PKG_NAME ,

Line 5888: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5884: Debug('In OTHERS exception',l_mod_name,4);
5885: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5887: IF FND_MSG_PUB.Check_Msg_Level
5888: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5889: THEN
5890: FND_MSG_PUB.Add_Exc_Msg
5891: (G_PKG_NAME ,
5892: l_api_name );

Line 5890: FND_MSG_PUB.Add_Exc_Msg

5886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5887: IF FND_MSG_PUB.Check_Msg_Level
5888: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5889: THEN
5890: FND_MSG_PUB.Add_Exc_Msg
5891: (G_PKG_NAME ,
5892: l_api_name );
5893: END IF;
5894: FND_MSG_PUB.Count_And_Get

Line 5894: FND_MSG_PUB.Count_And_Get

5890: FND_MSG_PUB.Add_Exc_Msg
5891: (G_PKG_NAME ,
5892: l_api_name );
5893: END IF;
5894: FND_MSG_PUB.Count_And_Get
5895: (p_count => x_msg_count,
5896: p_data => x_msg_data );
5897: END IO_RCV_UPDATE_MOVE_OUT;
5898:

Line 5974: FND_MSG_PUB.initialize;

5970: END IF;
5971:
5972: -- Initialize message list if p_init_msg_list is set to TRUE.
5973: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5974: FND_MSG_PUB.initialize;
5975: END IF;
5976:
5977: -- Api body starts
5978: IF p_internal_order_flag = 'Y' then

Line 6050: FND_MSG_PUB.Count_And_Get

6046: COMMIT WORK;
6047: END IF;
6048:
6049: -- Standard call to get message count and IF count is get message info.
6050: FND_MSG_PUB.Count_And_Get
6051: (p_count => x_msg_count,
6052: p_data => x_msg_data );
6053: EXCEPTION
6054: WHEN FND_API.G_EXC_ERROR THEN

Line 6062: FND_MSG_PUB.Count_And_Get

6058: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6059: ROLLBACK TO SHIP_UPDATE;
6060: END IF;
6061: x_return_status := FND_API.G_RET_STS_ERROR ;
6062: FND_MSG_PUB.Count_And_Get
6063: (p_count => x_msg_count,
6064: p_data => x_msg_data );
6065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6066: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);

Line 6079: FND_MSG_PUB.Count_And_Get

6075: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6076: ROLLBACK TO SHIP_UPDATE;
6077: END IF;
6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6079: FND_MSG_PUB.Count_And_Get
6080: ( p_count => x_msg_count,
6081: p_data => x_msg_data );
6082: WHEN OTHERS THEN
6083: Debug('In OTHERS Exception',l_mod_name,4);

Line 6096: IF FND_MSG_PUB.Check_Msg_Level

6092: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6093: ROLLBACK TO SHIP_UPDATE;
6094: END IF;
6095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6096: IF FND_MSG_PUB.Check_Msg_Level
6097: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6098: THEN
6099: FND_MSG_PUB.Add_Exc_Msg
6100: (G_PKG_NAME ,

Line 6097: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6093: ROLLBACK TO SHIP_UPDATE;
6094: END IF;
6095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6096: IF FND_MSG_PUB.Check_Msg_Level
6097: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6098: THEN
6099: FND_MSG_PUB.Add_Exc_Msg
6100: (G_PKG_NAME ,
6101: l_api_name );

Line 6099: FND_MSG_PUB.Add_Exc_Msg

6095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6096: IF FND_MSG_PUB.Check_Msg_Level
6097: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6098: THEN
6099: FND_MSG_PUB.Add_Exc_Msg
6100: (G_PKG_NAME ,
6101: l_api_name );
6102: END IF;
6103: FND_MSG_PUB.Count_And_Get

Line 6103: FND_MSG_PUB.Count_And_Get

6099: FND_MSG_PUB.Add_Exc_Msg
6100: (G_PKG_NAME ,
6101: l_api_name );
6102: END IF;
6103: FND_MSG_PUB.Count_And_Get
6104: (p_count => x_msg_count,
6105: p_data => x_msg_data );
6106: END SHIP_UPDATE;
6107:

Line 6454: FND_MSG_PUB.initialize;

6450: END IF;
6451:
6452: -- Initialize message list if p_init_msg_list is set to TRUE.
6453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6454: FND_MSG_PUB.initialize;
6455: END IF;
6456:
6457: -- Api body starts
6458:

Line 6589: fnd_msg_pub.add;

6585: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6586: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6587: ELSE
6588: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6589: fnd_msg_pub.add;
6590: END IF;
6591: RAISE FND_API.G_EXC_ERROR;
6592: End;
6593:

Line 6693: fnd_msg_pub.add;

6689: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6690: ELSE
6691: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6692: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6693: fnd_msg_pub.add;
6694: END IF;
6695: RAISE FND_API.G_EXC_ERROR;
6696: END IF;
6697: END IF;

Line 6717: fnd_msg_pub.add;

6713: */
6714: IF ( l_error_level >= G_debug_level) THEN
6715: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6716: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6717: fnd_msg_pub.add;
6718: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6719: fnd_file.put_line(fnd_file.log, fnd_message.get);
6720: ELSE
6721: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');

Line 6723: fnd_msg_pub.add;

6719: fnd_file.put_line(fnd_file.log, fnd_message.get);
6720: ELSE
6721: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6722: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6723: fnd_msg_pub.add;
6724: fnd_file.put_line(fnd_file.log, fnd_message.get);
6725: /*Fixed for bug#5563369
6726: Correct message name CSD_INSTANCE_MISSING is used instead of
6727: CSD_INV_INSTANCE_ID.

Line 6735: fnd_msg_pub.add;

6731: When OTHERS then
6732: IF ( l_error_level >= G_debug_level) THEN
6733: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6734: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6735: fnd_msg_pub.add;
6736: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6737: fnd_file.put_line(fnd_file.log, fnd_message.get);
6738: ELSE
6739: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');

Line 6741: fnd_msg_pub.add;

6737: fnd_file.put_line(fnd_file.log, fnd_message.get);
6738: ELSE
6739: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6740: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6741: fnd_msg_pub.add;
6742: fnd_file.put_line(fnd_file.log, fnd_message.get);
6743: END IF;
6744: RAISE FND_API.G_EXC_ERROR;
6745: End;

Line 6783: fnd_msg_pub.add;

6779: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6780: ELSE
6781: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
6782: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6783: fnd_msg_pub.add;
6784: END IF;
6785: RAISE FND_API.G_EXC_ERROR;
6786: END IF;
6787:

Line 6905: FND_MSG_PUB.ADD;

6901:
6902: -- Log seeded messages for the number of processed records
6903: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
6904: fnd_message.set_token('TOT_REC',to_char(l_total_records));
6905: FND_MSG_PUB.ADD;
6906:
6907: -- Debug messages
6908: Debug(fnd_message.get,l_mod_name,1);
6909:

Line 6920: FND_MSG_PUB.Count_And_Get

6916: COMMIT WORK;
6917: END IF;
6918:
6919: -- Standard call to get message count and IF count is get message info.
6920: FND_MSG_PUB.Count_And_Get
6921: (p_count => x_msg_count,
6922: p_data => x_msg_data);
6923:
6924: EXCEPTION

Line 6929: FND_MSG_PUB.Count_And_Get

6925: WHEN FND_API.G_EXC_ERROR THEN
6926: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);
6927: ROLLBACK TO SO_SHIP_UPDATE;
6928: x_return_status := FND_API.G_RET_STS_ERROR ;
6929: FND_MSG_PUB.Count_And_Get
6930: (p_count => x_msg_count,
6931: p_data => x_msg_data );
6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6933: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);

Line 6936: FND_MSG_PUB.Count_And_Get

6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6933: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6934: ROLLBACK TO SO_SHIP_UPDATE;
6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: FND_MSG_PUB.Count_And_Get
6937: ( p_count => x_msg_count,
6938: p_data => x_msg_data );
6939: WHEN OTHERS THEN
6940: Debug('OTHERS Exception',l_mod_name,4);

Line 6943: IF FND_MSG_PUB.Check_Msg_Level

6939: WHEN OTHERS THEN
6940: Debug('OTHERS Exception',l_mod_name,4);
6941: ROLLBACK TO SO_SHIP_UPDATE;
6942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6943: IF FND_MSG_PUB.Check_Msg_Level
6944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6945: THEN
6946: FND_MSG_PUB.Add_Exc_Msg
6947: (G_PKG_NAME ,

Line 6944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6940: Debug('OTHERS Exception',l_mod_name,4);
6941: ROLLBACK TO SO_SHIP_UPDATE;
6942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6943: IF FND_MSG_PUB.Check_Msg_Level
6944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6945: THEN
6946: FND_MSG_PUB.Add_Exc_Msg
6947: (G_PKG_NAME ,
6948: l_api_name );

Line 6946: FND_MSG_PUB.Add_Exc_Msg

6942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6943: IF FND_MSG_PUB.Check_Msg_Level
6944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6945: THEN
6946: FND_MSG_PUB.Add_Exc_Msg
6947: (G_PKG_NAME ,
6948: l_api_name );
6949: END IF;
6950: FND_MSG_PUB.Count_And_Get

Line 6950: FND_MSG_PUB.Count_And_Get

6946: FND_MSG_PUB.Add_Exc_Msg
6947: (G_PKG_NAME ,
6948: l_api_name );
6949: END IF;
6950: FND_MSG_PUB.Count_And_Get
6951: (p_count => x_msg_count,
6952: p_data => x_msg_data );
6953: END SO_SHIP_UPDATE;
6954:

Line 7220: FND_MSG_PUB.initialize;

7216: END IF;
7217:
7218: -- Initialize message list if p_init_msg_list is set to TRUE.
7219: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7220: FND_MSG_PUB.initialize;
7221: END IF;
7222:
7223: -- Api body starts
7224:

Line 7248: fnd_msg_pub.add;

7244: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7245: ELSE
7246: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7247: fnd_message.set_token('HEADER_ID',p_order_header_id);
7248: fnd_msg_pub.add;
7249: END IF;
7250: RAISE FND_API.G_EXC_ERROR;
7251: END;
7252: END IF;

Line 7297: fnd_msg_pub.add;

7293: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7294: ELSE
7295: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7296: fnd_message.set_token('HEADER_ID',DEL.header_id);
7297: fnd_msg_pub.add;
7298: END IF;
7299: RAISE FND_API.G_EXC_ERROR;
7300: END;
7301:

Line 7397: fnd_msg_pub.add;

7393: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7394: ELSE
7395: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7396: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7397: fnd_msg_pub.add;
7398: END IF;
7399: RAISE PROCESS_ERROR;
7400: END IF;
7401:

Line 7423: fnd_msg_pub.add;

7419: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7420: ELSE
7421: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7422: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7423: fnd_msg_pub.add;
7424: END IF;
7425: RAISE PROCESS_ERROR;
7426: End;
7427: Begin

Line 7489: fnd_msg_pub.add;

7485: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7486: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7487: ELSE
7488: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7489: fnd_msg_pub.add;
7490: END IF;
7491: RAISE PROCESS_ERROR;
7492: END;
7493: END IF;

Line 7554: fnd_msg_pub.add;

7550: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7551: ELSE
7552: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7553: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7554: fnd_msg_pub.add;
7555: END IF;
7556: RAISE PROCESS_ERROR;
7557: END IF;
7558: ELSE

Line 7585: fnd_msg_pub.add;

7581: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7582: ELSE
7583: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7584: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7585: fnd_msg_pub.add;
7586: END IF;
7587: RAISE PROCESS_ERROR;
7588: END IF;
7589: END IF;

Line 7712: fnd_msg_pub.add;

7708: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7709: ELSE
7710: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7711: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7712: fnd_msg_pub.add;
7713: END IF;
7714: RAISE PROCESS_ERROR;
7715: END IF;
7716:

Line 7738: fnd_msg_pub.add;

7734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7735: ELSE
7736: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7737: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7738: fnd_msg_pub.add;
7739: END IF;
7740: RAISE PROCESS_ERROR;
7741: End;
7742: Begin

Line 7805: fnd_msg_pub.add;

7801: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7802: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7803: ELSE
7804: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7805: fnd_msg_pub.add;
7806: END IF;
7807: RAISE PROCESS_ERROR;
7808: END;
7809: END IF; -- end if prod_txn_exists

Line 7829: FND_MSG_PUB.ADD;

7825: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7826: ELSE
7827: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7828: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7829: FND_MSG_PUB.ADD;
7830: END IF;
7831: RAISE PROCESS_ERROR;
7832: END IF;
7833:

Line 7958: FND_MSG_PUB.ADD;

7954: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7955: ELSE
7956: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
7957: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7958: FND_MSG_PUB.ADD;
7959: END IF;
7960: RAISE PROCESS_ERROR;
7961: END IF;
7962:

Line 7979: FND_MSG_PUB.ADD;

7975: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7976: ELSE
7977: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7978: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7979: FND_MSG_PUB.ADD;
7980: END IF;
7981: RAISE PROCESS_ERROR;
7982: END IF;
7983: -- product txn exist

Line 8077: FND_MSG_PUB.ADD;

8073: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8074: ELSE
8075: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8076: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8077: FND_MSG_PUB.ADD;
8078: END IF;
8079: RAISE PROCESS_ERROR;
8080: END IF;
8081:

Line 8098: FND_MSG_PUB.ADD;

8094: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8095: ELSE
8096: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8097: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8098: FND_MSG_PUB.ADD;
8099: END IF;
8100: RAISE PROCESS_ERROR;
8101: END IF;
8102: Exception

Line 8214: FND_MSG_PUB.ADD;

8210: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8211: ELSE
8212: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8213: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8214: FND_MSG_PUB.ADD;
8215: END IF;
8216: RAISE PROCESS_ERROR;
8217: END IF;
8218:

Line 8235: FND_MSG_PUB.ADD;

8231: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8232: ELSE
8233: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8234: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8235: FND_MSG_PUB.ADD;
8236: END IF;
8237: RAISE PROCESS_ERROR;
8238: END IF;
8239: -- product txn exist

Line 8333: FND_MSG_PUB.ADD;

8329: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8330: ELSE
8331: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8332: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8333: FND_MSG_PUB.ADD;
8334: END IF;
8335: RAISE PROCESS_ERROR;
8336: END IF;
8337:

Line 8354: FND_MSG_PUB.ADD;

8350: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8351: ELSE
8352: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8353: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8354: FND_MSG_PUB.ADD;
8355: END IF;
8356: RAISE PROCESS_ERROR;
8357: END IF;
8358: Exception

Line 8454: FND_MSG_PUB.Count_And_Get

8450: COMMIT WORK;
8451: END IF;
8452:
8453: -- Standard call to get message count and IF count is get message info.
8454: FND_MSG_PUB.Count_And_Get
8455: (p_count => x_msg_count,
8456: p_data => x_msg_data);
8457:
8458: EXCEPTION

Line 8462: FND_MSG_PUB.Count_And_Get

8458: EXCEPTION
8459: WHEN FND_API.G_EXC_ERROR THEN
8460: ROLLBACK TO IO_SHIP_UPDATE;
8461: x_return_status := FND_API.G_RET_STS_ERROR ;
8462: FND_MSG_PUB.Count_And_Get
8463: (p_count => x_msg_count,
8464: p_data => x_msg_data );
8465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8466: ROLLBACK TO IO_SHIP_UPDATE;

Line 8468: FND_MSG_PUB.Count_And_Get

8464: p_data => x_msg_data );
8465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8466: ROLLBACK TO IO_SHIP_UPDATE;
8467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8468: FND_MSG_PUB.Count_And_Get
8469: ( p_count => x_msg_count,
8470: p_data => x_msg_data );
8471: WHEN OTHERS THEN
8472: ROLLBACK TO IO_SHIP_UPDATE;

Line 8474: IF FND_MSG_PUB.Check_Msg_Level

8470: p_data => x_msg_data );
8471: WHEN OTHERS THEN
8472: ROLLBACK TO IO_SHIP_UPDATE;
8473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8474: IF FND_MSG_PUB.Check_Msg_Level
8475: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8476: THEN
8477: FND_MSG_PUB.Add_Exc_Msg
8478: (G_PKG_NAME ,

Line 8475: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8471: WHEN OTHERS THEN
8472: ROLLBACK TO IO_SHIP_UPDATE;
8473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8474: IF FND_MSG_PUB.Check_Msg_Level
8475: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8476: THEN
8477: FND_MSG_PUB.Add_Exc_Msg
8478: (G_PKG_NAME ,
8479: l_api_name );

Line 8477: FND_MSG_PUB.Add_Exc_Msg

8473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8474: IF FND_MSG_PUB.Check_Msg_Level
8475: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8476: THEN
8477: FND_MSG_PUB.Add_Exc_Msg
8478: (G_PKG_NAME ,
8479: l_api_name );
8480: END IF;
8481: FND_MSG_PUB.Count_And_Get

Line 8481: FND_MSG_PUB.Count_And_Get

8477: FND_MSG_PUB.Add_Exc_Msg
8478: (G_PKG_NAME ,
8479: l_api_name );
8480: END IF;
8481: FND_MSG_PUB.Count_And_Get
8482: (p_count => x_msg_count,
8483: p_data => x_msg_data );
8484:
8485: END IO_SHIP_UPDATE;

Line 8559: FND_MSG_PUB.initialize;

8555: END IF;
8556:
8557: -- Initialize message list if p_init_msg_list is set to TRUE.
8558: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8559: FND_MSG_PUB.initialize;
8560: END IF;
8561:
8562: -- Api body starts
8563:

Line 8627: FND_MSG_PUB.Count_And_Get

8623: COMMIT WORK;
8624: END IF;
8625:
8626: -- Standard call to get message count and IF count is get message info.
8627: FND_MSG_PUB.Count_And_Get
8628: (p_count => x_msg_count,
8629: p_data => x_msg_data);
8630: EXCEPTION
8631: WHEN FND_API.G_EXC_ERROR THEN

Line 8639: FND_MSG_PUB.Count_And_Get

8635: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8636: ROLLBACK TO WIP_UPDATE;
8637: END IF;
8638: x_return_status := FND_API.G_RET_STS_ERROR ;
8639: FND_MSG_PUB.Count_And_Get
8640: (p_count => x_msg_count,
8641: p_data => x_msg_data );
8642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8643: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);

Line 8656: FND_MSG_PUB.Count_And_Get

8652: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8653: ROLLBACK TO WIP_UPDATE;
8654: END IF;
8655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8656: FND_MSG_PUB.Count_And_Get
8657: ( p_count => x_msg_count,
8658: p_data => x_msg_data );
8659: WHEN OTHERS THEN
8660: Debug('In OTHERS Exception',l_mod_name,4);

Line 8673: IF FND_MSG_PUB.Check_Msg_Level

8669: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8670: ROLLBACK TO WIP_UPDATE;
8671: END IF;
8672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8673: IF FND_MSG_PUB.Check_Msg_Level
8674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8675: THEN
8676: FND_MSG_PUB.Add_Exc_Msg
8677: (G_PKG_NAME ,

Line 8674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8670: ROLLBACK TO WIP_UPDATE;
8671: END IF;
8672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8673: IF FND_MSG_PUB.Check_Msg_Level
8674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8675: THEN
8676: FND_MSG_PUB.Add_Exc_Msg
8677: (G_PKG_NAME ,
8678: l_api_name );

Line 8676: FND_MSG_PUB.Add_Exc_Msg

8672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8673: IF FND_MSG_PUB.Check_Msg_Level
8674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8675: THEN
8676: FND_MSG_PUB.Add_Exc_Msg
8677: (G_PKG_NAME ,
8678: l_api_name );
8679: END IF;
8680: FND_MSG_PUB.Count_And_Get

Line 8680: FND_MSG_PUB.Count_And_Get

8676: FND_MSG_PUB.Add_Exc_Msg
8677: (G_PKG_NAME ,
8678: l_api_name );
8679: END IF;
8680: FND_MSG_PUB.Count_And_Get
8681: (p_count => x_msg_count,
8682: p_data => x_msg_data );
8683: End WIP_UPDATE;
8684:

Line 8779: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

8775: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8776: -- Concatenate the message from the message stack
8777: IF l_msg_count > 1 then
8778: FOR i IN 1..l_msg_count LOOP
8779: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8780: END LOOP ;
8781: END IF ;
8782: Debug(l_msg_data,l_mod_name,4);
8783: RAISE FND_API.G_EXC_ERROR;

Line 8878: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

8874: -- Raise error message if the API returns status <> 'S'
8875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8876: IF l_msg_count > 1 then
8877: FOR i IN 1..l_msg_count LOOP
8878: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8879: END LOOP ;
8880: END IF ;
8881: Debug(l_msg_data,l_mod_name,4);
8882: RAISE FND_API.G_EXC_ERROR;

Line 8986: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

8982: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8983: -- Concatenate the message from the message stack
8984: IF l_msg_count > 1 then
8985: FOR i IN 1..l_msg_count LOOP
8986: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8987: END LOOP ;
8988: END IF ;
8989: Debug(l_msg_data,l_mod_name,4);
8990: RAISE FND_API.G_EXC_ERROR ;

Line 9298: FND_MSG_PUB.Count_And_Get

9294: COMMIT WORK;
9295: END IF;
9296:
9297: -- Standard call to get message count and IF count is get message info.
9298: FND_MSG_PUB.Count_And_Get
9299: (p_count => x_msg_count,
9300: p_data => x_msg_data );
9301:
9302: EXCEPTION

Line 9306: FND_MSG_PUB.Count_And_Get

9302: EXCEPTION
9303: WHEN FND_API.G_EXC_ERROR THEN
9304: ROLLBACK TO Update_rep_task_hist;
9305: x_return_status := FND_API.G_RET_STS_ERROR ;
9306: FND_MSG_PUB.Count_And_Get
9307: (p_count => x_msg_count,
9308: p_data => x_msg_data );
9309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 9312: FND_MSG_PUB.Count_And_Get

9308: p_data => x_msg_data );
9309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9311: ROLLBACK TO Update_rep_task_hist;
9312: FND_MSG_PUB.Count_And_Get
9313: ( p_count => x_msg_count,
9314: p_data => x_msg_data );
9315: WHEN OTHERS THEN
9316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 9318: IF FND_MSG_PUB.Check_Msg_Level

9314: p_data => x_msg_data );
9315: WHEN OTHERS THEN
9316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9317: ROLLBACK TO Update_rep_task_hist;
9318: IF FND_MSG_PUB.Check_Msg_Level
9319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9320: THEN
9321: FND_MSG_PUB.Add_Exc_Msg
9322: (G_PKG_NAME ,

Line 9319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9315: WHEN OTHERS THEN
9316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9317: ROLLBACK TO Update_rep_task_hist;
9318: IF FND_MSG_PUB.Check_Msg_Level
9319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9320: THEN
9321: FND_MSG_PUB.Add_Exc_Msg
9322: (G_PKG_NAME ,
9323: l_api_name );

Line 9321: FND_MSG_PUB.Add_Exc_Msg

9317: ROLLBACK TO Update_rep_task_hist;
9318: IF FND_MSG_PUB.Check_Msg_Level
9319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9320: THEN
9321: FND_MSG_PUB.Add_Exc_Msg
9322: (G_PKG_NAME ,
9323: l_api_name );
9324: END IF;
9325: FND_MSG_PUB.Count_And_Get

Line 9325: FND_MSG_PUB.Count_And_Get

9321: FND_MSG_PUB.Add_Exc_Msg
9322: (G_PKG_NAME ,
9323: l_api_name );
9324: END IF;
9325: FND_MSG_PUB.Count_And_Get
9326: (p_count => x_msg_count,
9327: p_data => x_msg_data );
9328:
9329: END TASK_UPDATE_CONC_PROG;