653: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
654: p_token => g_progress,
655: p_message => 'PO_PDOI_DOC_NUM_UNIQUE');
656: END IF;
657: Fnd_message.set_name('PO','PO_PDOI_DOC_NUM_UNIQUE');
658: Fnd_message.set_token( token => 'VALUE'
659: , VALUE => g_cpa_csr.document_num);
660: FND_MSG_PUB.Add;
661:
654: p_token => g_progress,
655: p_message => 'PO_PDOI_DOC_NUM_UNIQUE');
656: END IF;
657: Fnd_message.set_name('PO','PO_PDOI_DOC_NUM_UNIQUE');
658: Fnd_message.set_token( token => 'VALUE'
659: , VALUE => g_cpa_csr.document_num);
660: FND_MSG_PUB.Add;
661:
662: RAISE FND_API.G_EXC_ERROR;
667: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
668: p_token => g_progress,
669: p_message => 'PO_PDOI_VALUE_NUMERIC');
670: END IF;
671: Fnd_message.set_name('PO','PO_PDOI_VALUE_NUMERIC');
672: Fnd_message.set_token( token => 'COLUMN_NAME'
673: , VALUE => 'Document Number');
674: Fnd_message.set_token( token => 'VALUE'
675: , VALUE => g_cpa_csr.document_num);
668: p_token => g_progress,
669: p_message => 'PO_PDOI_VALUE_NUMERIC');
670: END IF;
671: Fnd_message.set_name('PO','PO_PDOI_VALUE_NUMERIC');
672: Fnd_message.set_token( token => 'COLUMN_NAME'
673: , VALUE => 'Document Number');
674: Fnd_message.set_token( token => 'VALUE'
675: , VALUE => g_cpa_csr.document_num);
676: FND_MSG_PUB.Add;
670: END IF;
671: Fnd_message.set_name('PO','PO_PDOI_VALUE_NUMERIC');
672: Fnd_message.set_token( token => 'COLUMN_NAME'
673: , VALUE => 'Document Number');
674: Fnd_message.set_token( token => 'VALUE'
675: , VALUE => g_cpa_csr.document_num);
676: FND_MSG_PUB.Add;
677: RAISE FND_API.G_EXC_ERROR;
678: ELSIF (l_error_code = 'PO_PDOI_LT_ZERO') THEN
681: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
682: p_token => g_progress,
683: p_message => 'PO_PDOI_LT_ZERO');
684: END IF;
685: Fnd_message.set_name('PO','PO_PDOI_LT_ZERO');
686: Fnd_message.set_token( token => 'COLUMN_NAME'
687: , VALUE => 'Document Number');
688: Fnd_message.set_token( token => 'VALUE'
689: , VALUE => g_cpa_csr.document_num);
682: p_token => g_progress,
683: p_message => 'PO_PDOI_LT_ZERO');
684: END IF;
685: Fnd_message.set_name('PO','PO_PDOI_LT_ZERO');
686: Fnd_message.set_token( token => 'COLUMN_NAME'
687: , VALUE => 'Document Number');
688: Fnd_message.set_token( token => 'VALUE'
689: , VALUE => g_cpa_csr.document_num);
690: FND_MSG_PUB.Add;
684: END IF;
685: Fnd_message.set_name('PO','PO_PDOI_LT_ZERO');
686: Fnd_message.set_token( token => 'COLUMN_NAME'
687: , VALUE => 'Document Number');
688: Fnd_message.set_token( token => 'VALUE'
689: , VALUE => g_cpa_csr.document_num);
690: FND_MSG_PUB.Add;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
700: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
701: p_token => g_progress,
702: p_message => 'PO_PDOI_COLUMN_NOT_NULL');
703: END IF;
704: Fnd_message.set_name('PO','PO_PDOI_COLUMN_NOT_NULL');
705: Fnd_message.set_token( token => 'COLUMN_NAME'
706: , VALUE => 'Document Number');
707: FND_MSG_PUB.Add;
708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: p_token => g_progress,
702: p_message => 'PO_PDOI_COLUMN_NOT_NULL');
703: END IF;
704: Fnd_message.set_name('PO','PO_PDOI_COLUMN_NOT_NULL');
705: Fnd_message.set_token( token => 'COLUMN_NAME'
706: , VALUE => 'Document Number');
707: FND_MSG_PUB.Add;
708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
709: END IF; -- End of IF g_cpa_csr.document_num IS NOT NULL
1576: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1577: p_token => g_progress,
1578: p_message => 'Insert_CPA: Inside l_contracts_call_exception');
1579: END IF;
1580: Fnd_message.set_name('PO','PO_API_ERROR');
1581: Fnd_message.set_token( token => 'PROC_CALLER'
1582: , VALUE => 'PO_INTERFACE_S.INSERT_CPA');
1583: Fnd_message.set_token( token => 'PROC_CALLED'
1584: , VALUE => 'OKC_TERMS_CPOY_GRP.COPY_DOC');
1577: p_token => g_progress,
1578: p_message => 'Insert_CPA: Inside l_contracts_call_exception');
1579: END IF;
1580: Fnd_message.set_name('PO','PO_API_ERROR');
1581: Fnd_message.set_token( token => 'PROC_CALLER'
1582: , VALUE => 'PO_INTERFACE_S.INSERT_CPA');
1583: Fnd_message.set_token( token => 'PROC_CALLED'
1584: , VALUE => 'OKC_TERMS_CPOY_GRP.COPY_DOC');
1585: FND_MSG_PUB.Add;
1579: END IF;
1580: Fnd_message.set_name('PO','PO_API_ERROR');
1581: Fnd_message.set_token( token => 'PROC_CALLER'
1582: , VALUE => 'PO_INTERFACE_S.INSERT_CPA');
1583: Fnd_message.set_token( token => 'PROC_CALLED'
1584: , VALUE => 'OKC_TERMS_CPOY_GRP.COPY_DOC');
1585: FND_MSG_PUB.Add;
1586:
1587: IF g_debug_stmt THEN
1601: p_message => 'PO_SOURCING_PVT.INSERT_CPA: Inside l_uda_template_exception'
1602: );
1603: END IF;
1604:
1605: fnd_message.set_name ('PO', 'PO_UDA_TEMPLATE_ID_NULL');
1606: fnd_msg_pub.ADD;
1607: x_return_status := FND_API.G_RET_STS_ERROR;
1608:
1609: WHEN OTHERS THEN
1704: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1705: p_token => g_progress,
1706: p_message => 'PO_ALL_NO_DRILLDOWN: '||SQLERRM);
1707: END IF;
1708: Fnd_message.set_name('PO','PO_ALL_NO_DRILLDOWN');
1709: FND_MSG_PUB.Add;
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712:
1869: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1870: p_token => g_progress,
1871: p_message => 'Invalid Action in the interface table');
1872: END IF;
1873: Fnd_message.set_name('PO','PO_PDOI_INVALID_ACTION');
1874: Fnd_message.set_token( token => 'VALUE'
1875: , VALUE => g_cpa_csr.action);
1876: FND_MSG_PUB.Add;
1877: RAISE FND_API.G_EXC_ERROR;
1870: p_token => g_progress,
1871: p_message => 'Invalid Action in the interface table');
1872: END IF;
1873: Fnd_message.set_name('PO','PO_PDOI_INVALID_ACTION');
1874: Fnd_message.set_token( token => 'VALUE'
1875: , VALUE => g_cpa_csr.action);
1876: FND_MSG_PUB.Add;
1877: RAISE FND_API.G_EXC_ERROR;
1878: END IF; -- End of l_action = 'NEW'
1882: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1883: p_token => g_progress,
1884: p_message => 'Invalid Document Subtype Code in the interface table');
1885: END IF;
1886: Fnd_message.set_name('PO','PO_PDOI_INVALID_VALUE');
1887: Fnd_message.set_token( token => 'COLUMN_NAME'
1888: , VALUE => 'Document Subtype');
1889: Fnd_message.set_token( token => 'VALUE'
1890: , VALUE => 'CONTRACT');
1883: p_token => g_progress,
1884: p_message => 'Invalid Document Subtype Code in the interface table');
1885: END IF;
1886: Fnd_message.set_name('PO','PO_PDOI_INVALID_VALUE');
1887: Fnd_message.set_token( token => 'COLUMN_NAME'
1888: , VALUE => 'Document Subtype');
1889: Fnd_message.set_token( token => 'VALUE'
1890: , VALUE => 'CONTRACT');
1891: FND_MSG_PUB.Add;
1885: END IF;
1886: Fnd_message.set_name('PO','PO_PDOI_INVALID_VALUE');
1887: Fnd_message.set_token( token => 'COLUMN_NAME'
1888: , VALUE => 'Document Subtype');
1889: Fnd_message.set_token( token => 'VALUE'
1890: , VALUE => 'CONTRACT');
1891: FND_MSG_PUB.Add;
1892:
1893: RAISE FND_API.G_EXC_ERROR;