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.PO_CHANGEORDERWF_PVT dependencies on FND_LOG

Line 167: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

163: wf_engine.StartProcess( ItemType => 'POSCHORD',
164: ItemKey => l_item_key);
165: END IF;
166: exception when others then
167: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
168: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
169: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
170: END IF;
171:

Line 168: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

164: ItemKey => l_item_key);
165: END IF;
166: exception when others then
167: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
168: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
169: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
170: END IF;
171:
172: END Notify_Requester_Sup_Change;

Line 263: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

259: wf_engine.StartProcess( ItemType => 'POSCHORD',
260: ItemKey => l_item_key);
261: END IF;
262: exception when others then
263: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
265: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
266: END IF;
267:

Line 264: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

260: ItemKey => l_item_key);
261: END IF;
262: exception when others then
263: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
265: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
266: END IF;
267:
268: END Notify_Planner_Sup_Change;

Line 479: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

475: END IF;
476:
477: commit;
478: exception when others then
479: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
481: l_api_name || '.others_exception',sqlerrm);
482: END IF;
483: End Update_Chg_Req_If_Po_Apprvd;

Line 480: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

476:
477: commit;
478: exception when others then
479: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
481: l_api_name || '.others_exception',sqlerrm);
482: END IF;
483: End Update_Chg_Req_If_Po_Apprvd;
484:

Line 585: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582: end if;
583:
584: exception when others then
585: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
586: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
587: l_api_name || '.others_exception', sqlerrm);
588: END IF;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 586: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

582: end if;
583:
584: exception when others then
585: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
586: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
587: l_api_name || '.others_exception', sqlerrm);
588: END IF;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: --Restoring PO's Authorization status back to "IN PROCESS".

Line 805: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

801: close l_cancel_hdr_csr;
802:
803: exception when others then
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
807: l_api_name || '.others_exception', sqlerrm);
808: END IF;
809: end CancelPO;

Line 806: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

802:
803: exception when others then
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
807: l_api_name || '.others_exception', sqlerrm);
808: END IF;
809: end CancelPO;
810:

Line 974: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

970: --Bug 6772960 - End
971:
972: exception
973: when others then
974: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
975: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
976: l_api_name || '.others_exception', sqlerrm);
977: END IF;
978: raise;

Line 975: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

971:
972: exception
973: when others then
974: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
975: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
976: l_api_name || '.others_exception', sqlerrm);
977: END IF;
978: raise;
979: end;

Line 1139: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1135: Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'N');
1136:
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1140: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1141: l_api_name || '.others_exception', sqlerrm);
1142: END IF;
1143: wf_core.context('PO_ChangeOrderWF_PVT','Register_rejection',l_progress);

Line 1140: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1136:
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1140: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1141: l_api_name || '.others_exception', sqlerrm);
1142: END IF;
1143: wf_core.context('PO_ChangeOrderWF_PVT','Register_rejection',l_progress);
1144: raise;

Line 1302: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1298:
1299:
1300:
1301: x_return_msg:='004';
1302: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1303: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
1304: l_api_name || '.start_wf_process', l_Item_Type||'*'||l_Item_Key);
1305: END IF;
1306:

Line 1303: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||

1299:
1300:
1301: x_return_msg:='004';
1302: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1303: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
1304: l_api_name || '.start_wf_process', l_Item_Type||'*'||l_Item_Key);
1305: END IF;
1306:
1307: IF( (l_Document_Type_Code = 'RELEASE' AND l_Document_Subtype = 'BLANKET') OR (l_Document_Type_Code = 'PO' AND l_Document_Subtype = 'STANDARD') ) THEN

Line 1333: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: exception when others then
1331: x_return_msg:='KO_U'||x_return_msg||sqlerrm;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1333: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1334: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1335: l_api_name || '.others_exception', x_return_msg);
1336: END IF;
1337:

Line 1334: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1330: exception when others then
1331: x_return_msg:='KO_U'||x_return_msg||sqlerrm;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1333: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1334: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1335: l_api_name || '.others_exception', x_return_msg);
1336: END IF;
1337:
1338: END KickOffPOApproval;

Line 4173: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

4169: WF_NOTIFICATION.WriteToClob(document,l_document);
4170: end if;
4171: exception when others then
4172: IF g_fnd_debug = 'Y' THEN
4173: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
4174: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
4175: END IF;
4176: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); */
4177: null;

Line 4944: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

4940: WF_NOTIFICATION.WriteToClob(document,'GEN_NTF_FOR_SUP_BUY_RP for no html customer');
4941: end if;
4942: exception when others then
4943: IF g_fnd_debug = 'Y' THEN
4944: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
4945: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
4946: END IF;
4947: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); */
4948: null;

Line 6517: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6513: x_return_status,
6514: x_complex_flag);
6515:
6516: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
6517: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6519: g_module_prefix,
6520: x_progress || 'x_return_status=' || x_return_status || 'x_complex_flag ' || x_complex_flag);
6521: END IF;

Line 6518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

6514: x_complex_flag);
6515:
6516: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
6517: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6519: g_module_prefix,
6520: x_progress || 'x_return_status=' || x_return_status || 'x_complex_flag ' || x_complex_flag);
6521: END IF;
6522:

Line 6524: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6520: x_progress || 'x_return_status=' || x_return_status || 'x_complex_flag ' || x_complex_flag);
6521: END IF;
6522:
6523: ELSE
6524: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6525: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
6526: g_module_prefix,
6527: x_progress ||'x_return_status = ' || x_return_status);
6528: END IF;

Line 6525: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

6521: END IF;
6522:
6523: ELSE
6524: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6525: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
6526: g_module_prefix,
6527: x_progress ||'x_return_status = ' || x_return_status);
6528: END IF;
6529: END IF;

Line 6970: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6966: x_return_status,
6967: x_complex_flag);
6968:
6969: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
6970: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6971: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6972: g_module_prefix,
6973: l_progress
6974: || 'x_return_status=' || x_return_status

Line 6971: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

6967: x_complex_flag);
6968:
6969: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
6970: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6971: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6972: g_module_prefix,
6973: l_progress
6974: || 'x_return_status=' || x_return_status
6975: || 'x_complex_flag ' || x_complex_flag);

Line 6979: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6975: || 'x_complex_flag ' || x_complex_flag);
6976: END IF;
6977:
6978: ELSE
6979: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6980: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
6981: g_module_prefix,
6982: l_progress
6983: ||'x_return_status = ' || x_return_status);

Line 6980: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

6976: END IF;
6977:
6978: ELSE
6979: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6980: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
6981: g_module_prefix,
6982: l_progress
6983: ||'x_return_status = ' || x_return_status);
6984: END IF;

Line 7033: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7029: wf_engine.StartProcess( ItemType => 'POSCHORD',
7030: ItemKey => l_item_key);
7031:
7032: exception when others then
7033: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7034: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7035: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
7036: END IF;
7037: END NotifySupAllChgRpdWF;

Line 7034: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

7030: ItemKey => l_item_key);
7031:
7032: exception when others then
7033: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7034: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7035: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
7036: END IF;
7037: END NotifySupAllChgRpdWF;
7038:

Line 7100: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7096: p_revision_num, l_chn_req_grp_id, p_user_id, l_retmsg,
7097: l_retcode, l_doc_check_rec_type, null, 'Y');
7098:
7099: exception when others then
7100: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7101: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7102: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
7103: END IF;
7104: x_return_status := 'U';

Line 7101: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

7097: l_retcode, l_doc_check_rec_type, null, 'Y');
7098:
7099: exception when others then
7100: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7101: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7102: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
7103: END IF;
7104: x_return_status := 'U';
7105: End ProcessHdrCancelResponse;

Line 7414: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7410: */
7411: end if;
7412:
7413: exception when others then
7414: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7415: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7416: l_api_name || '.others_exception', x_progress||':'||sqlerrm);
7417: END IF;
7418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7415: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

7411: end if;
7412:
7413: exception when others then
7414: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7415: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7416: l_api_name || '.others_exception', x_progress||':'||sqlerrm);
7417: END IF;
7418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7419: x_err_msg := x_progress||'*'||sqlerrm;

Line 7728: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7724: x_complex_flag varchar2(1);
7725:
7726:
7727: BEGIN
7728: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7729: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
7730: l_api_name || 'start',p_header_id||'*'||p_release_id||'*'||p_revision_num||'*'||p_chg_req_grp_id);
7731: END IF;
7732:

Line 7729: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||

7725:
7726:
7727: BEGIN
7728: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7729: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
7730: l_api_name || 'start',p_header_id||'*'||p_release_id||'*'||p_revision_num||'*'||p_chg_req_grp_id);
7731: END IF;
7732:
7733: -- Start Workflow

Line 7812: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7808: x_ret_status,
7809: x_complex_flag);
7810:
7811: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
7812: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7814: g_module_prefix,
7815: l_progress
7816: || 'x_return_status=' || x_return_status);

Line 7813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

7809: x_complex_flag);
7810:
7811: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
7812: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7814: g_module_prefix,
7815: l_progress
7816: || 'x_return_status=' || x_return_status);
7817: END IF;

Line 7820: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7816: || 'x_return_status=' || x_return_status);
7817: END IF;
7818:
7819: ELSE
7820: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7821: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
7822: g_module_prefix,
7823: l_progress
7824: ||'x_return_status = ' || x_return_status);

Line 7821: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

7817: END IF;
7818:
7819: ELSE
7820: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7821: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
7822: g_module_prefix,
7823: l_progress
7824: ||'x_return_status = ' || x_return_status);
7825: END IF;

Line 7879: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7875: ItemKey => l_item_key);
7876:
7877: x_return_status := FND_API.G_RET_STS_SUCCESS;
7878: exception when others then
7879: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7880: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7881: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
7882: END IF;
7883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7880: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

7876:
7877: x_return_status := FND_API.G_RET_STS_SUCCESS;
7878: exception when others then
7879: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7880: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7881: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
7882: END IF;
7883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7884: end StartSupplierChangeWF;

Line 7990: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7986: end if;
7987:
7988: l_progress := '003';
7989:
7990: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7991: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
7992: l_api_name || '.intialize parameters',l_user_id||'*'||l_resp_id||'*'||l_resp_appl_id );
7993: END IF;
7994: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);

Line 7991: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||

7987:
7988: l_progress := '003';
7989:
7990: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7991: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
7992: l_api_name || '.intialize parameters',l_user_id||'*'||l_resp_id||'*'||l_resp_appl_id );
7993: END IF;
7994: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);
7995: exception when others then

Line 7996: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7992: l_api_name || '.intialize parameters',l_user_id||'*'||l_resp_id||'*'||l_resp_appl_id );
7993: END IF;
7994: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);
7995: exception when others then
7996: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7997: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7998: l_api_name || '.others_exception', sqlerrm);
7999: END IF;
8000: END initialize;

Line 7997: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

7993: END IF;
7994: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);
7995: exception when others then
7996: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7997: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7998: l_api_name || '.others_exception', sqlerrm);
7999: END IF;
8000: END initialize;
8001:

Line 8146: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

8142: END LOOP;
8143:
8144: CLOSE getReqNum;
8145:
8146: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8147: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.getReqNumber', l_req_num ||' * '|| l_req_header_id);
8148: END IF;
8149:
8150: x_req_num := TO_CHAR(l_req_num);

Line 8147: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.getReqNumber', l_req_num ||' * '|| l_req_header_id);

8143:
8144: CLOSE getReqNum;
8145:
8146: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8147: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.getReqNumber', l_req_num ||' * '|| l_req_header_id);
8148: END IF;
8149:
8150: x_req_num := TO_CHAR(l_req_num);
8151: x_req_hdr_id := TO_CHAR(l_req_header_id);

Line 8155: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8151: x_req_hdr_id := TO_CHAR(l_req_header_id);
8152:
8153: EXCEPTION
8154: WHEN OTHERS THEN
8155: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8156: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8157: g_module_prefix,
8158: ':unexpected error' || Sqlerrm);
8159: END IF;

Line 8156: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

8152:
8153: EXCEPTION
8154: WHEN OTHERS THEN
8155: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8156: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8157: g_module_prefix,
8158: ':unexpected error' || Sqlerrm);
8159: END IF;
8160:

Line 8199: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8195: end if;
8196:
8197: EXCEPTION
8198: WHEN OTHERS THEN
8199: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8200: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8201: g_module_prefix,
8202: ':unexpected error' || Sqlerrm);
8203: END IF;

Line 8200: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

8196:
8197: EXCEPTION
8198: WHEN OTHERS THEN
8199: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8200: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8201: g_module_prefix,
8202: ':unexpected error' || Sqlerrm);
8203: END IF;
8204:

Line 8349: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8345: x_revision_num := l_revision_num;
8346:
8347: EXCEPTION
8348: WHEN OTHERS THEN
8349: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8350: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8351: g_module_prefix,
8352: ':unexpected error' || Sqlerrm);
8353: END IF;

Line 8350: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

8346:
8347: EXCEPTION
8348: WHEN OTHERS THEN
8349: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8350: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8351: g_module_prefix,
8352: ':unexpected error' || Sqlerrm);
8353: END IF;
8354:

Line 8366: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

8362: PROCEDURE SET_SUPPLIER_CONTEXT(p_supplier_user_id in NUMBER,p_resp_id in NUMBER,p_appl_resp_id in NUMBER)
8363: IS
8364: BEGIN
8365:
8366: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8367: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.SET_SUPPLIER_CONTEXT', 'user_id:'||p_supplier_user_id||'resp:'||p_resp_id||'appl id:'||p_appl_resp_id );
8368: END IF;
8369:
8370: fnd_global.APPS_INITIALIZE(p_supplier_user_id, p_resp_id, p_appl_resp_id);

Line 8367: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.SET_SUPPLIER_CONTEXT', 'user_id:'||p_supplier_user_id||'resp:'||p_resp_id||'appl id:'||p_appl_resp_id );

8363: IS
8364: BEGIN
8365:
8366: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8367: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.SET_SUPPLIER_CONTEXT', 'user_id:'||p_supplier_user_id||'resp:'||p_resp_id||'appl id:'||p_appl_resp_id );
8368: END IF;
8369:
8370: fnd_global.APPS_INITIALIZE(p_supplier_user_id, p_resp_id, p_appl_resp_id);
8371:

Line 8374: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8370: fnd_global.APPS_INITIALIZE(p_supplier_user_id, p_resp_id, p_appl_resp_id);
8371:
8372: EXCEPTION
8373: WHEN OTHERS THEN
8374: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8375: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8376: g_module_prefix,
8377: ':unexpected error' || Sqlerrm);
8378: END IF;

Line 8375: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

8371:
8372: EXCEPTION
8373: WHEN OTHERS THEN
8374: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8375: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
8376: g_module_prefix,
8377: ':unexpected error' || Sqlerrm);
8378: END IF;
8379:

Line 8393: IF (g_fnd_debug = 'Y' AND FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8389: l_external_url varchar2(500);
8390: begin
8391:
8392: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
8393: IF (g_fnd_debug = 'Y' AND FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8394: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
8395: l_api_name || '.start', 'POS_EXTERNAL_URL=' || l_external_url);
8396: END IF;
8397: resultout := 'N:' || l_external_url;

Line 8394: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||

8390: begin
8391:
8392: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
8393: IF (g_fnd_debug = 'Y' AND FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8394: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
8395: l_api_name || '.start', 'POS_EXTERNAL_URL=' || l_external_url);
8396: END IF;
8397: resultout := 'N:' || l_external_url;
8398:

Line 8410: IF (g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8406: resultout := 'Y:' || l_external_url;
8407: end if;
8408:
8409: exception when others then
8410: IF (g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8411: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
8412: l_api_name || '.others_exception', sqlerrm);
8413: END IF;
8414: resultout := 'F:' || l_external_url;

Line 8411: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

8407: end if;
8408:
8409: exception when others then
8410: IF (g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8411: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
8412: l_api_name || '.others_exception', sqlerrm);
8413: END IF;
8414: resultout := 'F:' || l_external_url;
8415: return;