DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on IEX_DEBUG_PUB

Line 52: iex_debug_pub.logmessage ( 'in get message routine');

48: and lng.LANGUAGE_CODE = msg.language_code
49: and lng.language_id = x_lang_id;
50:
51: BEGIN
52: iex_debug_pub.logmessage ( 'in get message routine');
53: FOR l_count in 1..p_message_count LOOP
54:
55: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
56: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);

Line 84: iex_debug_pub.logmessage ( 'l_msg_lis'||l_msg_list);

80: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
81: END IF;
82:
83: l_msg_list := l_msg_list || '';
84: iex_debug_pub.logmessage ( 'l_msg_lis'||l_msg_list);
85: END LOOP;
86:
87: x_message := l_msg_list;
88: iex_debug_pub.logmessage ( ' x_message ' ||x_message);

Line 88: iex_debug_pub.logmessage ( ' x_message ' ||x_message);

84: iex_debug_pub.logmessage ( 'l_msg_lis'||l_msg_list);
85: END LOOP;
86:
87: x_message := l_msg_list;
88: iex_debug_pub.logmessage ( ' x_message ' ||x_message);
89: EXCEPTION
90: WHEN OTHERS THEN
91: x_message:=l_msg_list;
92: END Get_Messages;

Line 108: iex_debug_pub.logmessage ( 'in get message routine');

104: l_msg_data VARCHAR2(32627);
105: l_new_line VARCHAR2(10) := FND_GLOBAL.NEWLINE;
106:
107: BEGIN
108: iex_debug_pub.logmessage ( 'in get message routine');
109: FOR i IN 1..p_message_count
110: LOOP
111: fnd_msg_pub.get(p_data => l_msg_data,
112: p_msg_index_out => l_msg_count,

Line 122: iex_debug_pub.logmessage ( ' x_message ' ||x_message);

118: l_msg_list := l_msg_list || l_new_line || l_msg_data;
119: END IF;
120: END LOOP;
121: x_message:=l_msg_list;
122: iex_debug_pub.logmessage ( ' x_message ' ||x_message);
123: EXCEPTION
124: WHEN OTHERS THEN
125: x_message:=l_msg_list;
126: END Get_Messages1;

Line 197: iex_debug_pub.logmessage ('Event Key ' ||l_key ||'writeoff_type' ||p_writeoff_type||

193:
194: l_key := l_event_name ||'-'||p_request_id;
195:
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
197: iex_debug_pub.logmessage ('Event Key ' ||l_key ||'writeoff_type' ||p_writeoff_type||
198: 'object_id'||p_object_id|| 'request_id'||p_request_id);
199: END IF;
200:
201: l_amount :=0;

Line 213: iex_debug_pub.logmessage ('in contracts' ||'writeoff_type' ||p_writeoff_type||

209: FETCH c_get_cont_invoices INTO l_object_id, l_amount, l_currency_code;
210: CLOSE c_get_cont_invoices;
211:
212: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
213: iex_debug_pub.logmessage ('in contracts' ||'writeoff_type' ||p_writeoff_type||
214: 'object_id'||p_object_id|| 'request_id'||p_request_id);
215: end if;
216: end if;
217:

Line 219: iex_debug_pub.logmessage ('Get notify Agent User ID.....' ||l_user_id);

215: end if;
216: end if;
217:
218: begin
219: iex_debug_pub.logmessage ('Get notify Agent User ID.....' ||l_user_id);
220: OPEN c_get_agent(l_user_id) ;
221: FETCH c_get_agent INTO l_notification_agent;
222: if c_get_agent%NOTFOUND then null; end if;
223: CLOSE c_get_Agent;

Line 234: iex_debug_pub.logmessage ('l_case_number ' ||l_case_number || 'l_case_owner' || l_case_owner

230: END IF;
231:
232:
233: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
234: iex_debug_pub.logmessage ('l_case_number ' ||l_case_number || 'l_case_owner' || l_case_owner
235: ||'<-----L_AMOUNT----->' ||l_amount);
236: END IF;
237:
238: wf_event.AddParameterToList('AMOUNT', to_char(l_amount), l_parameter_list);

Line 249: iex_debug_pub.logmessage ('before launching workflow');

245: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
246: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
247:
248: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
249: iex_debug_pub.logmessage ('before launching workflow');
250: END IF;
251:
252: wf_event.raise(p_event_name => l_event_name
253: ,p_event_key => l_key

Line 259: iex_debug_pub.logmessage ('Successfully launched writeoff workflow');

255: COMMIT ;
256: l_parameter_list.DELETE;
257:
258: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
259: iex_debug_pub.logmessage ('Successfully launched writeoff workflow');
260: END IF;
261:
262: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
263: EXCEPTION

Line 326: iex_debug_pub.logmessage ('Event Key ' ||l_key);

322:
323: l_key := l_event_name ||'-'||p_request_id;
324:
325: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
326: iex_debug_pub.logmessage ('Event Key ' ||l_key);
327: END IF;
328:
329: OPEN c_get_case_owner(p_object_id);
330: FETCH c_get_case_owner INTO l_case_owner, l_contract_number;

Line 334: iex_debug_pub.logmessage ('l_contract_number ' ||l_contract_number

330: FETCH c_get_case_owner INTO l_case_owner, l_contract_number;
331: CLOSE c_get_case_owner;
332:
333: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
334: iex_debug_pub.logmessage ('l_contract_number ' ||l_contract_number
335: || 'l_case_owner' || l_case_owner);
336: END IF;
337:
338: begin

Line 357: iex_debug_pub.logmessage ('before launching workflow');

353: wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
354: wf_event.AddParameterToList('CONTRACT_NUMBER', l_contract_number, l_parameter_list);
355:
356: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
357: iex_debug_pub.logmessage ('before launching workflow');
358: END IF;
359:
360: wf_event.raise(p_event_name => l_event_name
361: ,p_event_key => l_key

Line 368: iex_debug_pub.logmessage ('Successfully launched asset mgr workflow');

364: COMMIT ;
365: l_parameter_list.DELETE;
366:
367: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
368: iex_debug_pub.logmessage ('Successfully launched asset mgr workflow');
369: END IF;
370:
371: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
372: EXCEPTION

Line 451: iex_debug_pub.logmessage ('writeoff creation object ID '||

447: ,x_msg_count =>l_msg_count
448: ,x_msg_data =>l_msg_data);
449:
450: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
451: iex_debug_pub.logmessage ('writeoff creation object ID '||
452: l_writeoff_object_id || 'status ' ||l_return_status);
453: END IF;
454:
455: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 458: iex_debug_pub.logmessage('Error' ||l_message);

454:
455: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
456: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
458: iex_debug_pub.logmessage('Error' ||l_message);
459: END IF;
460: raise FND_API.G_EXC_ERROR;
461:
462: ELSE

Line 490: iex_debug_pub.logmessage('Error' ||l_message);

486:
487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
488: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
490: iex_debug_pub.logmessage('Error' ||l_message);
491: END IF;
492: raise FND_API.G_EXC_ERROR;
493: ELSE
494: FND_MSG_PUB.initialize;

Line 496: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number

492: raise FND_API.G_EXC_ERROR;
493: ELSE
494: FND_MSG_PUB.initialize;
495: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
496: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
497: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id);
498: end if;
499: END IF;
500:

Line 668: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);

664: ,p_adjv_rec =>l_adjv_rec
665: ,x_adjv_rec =>x_adjv_rec);
666:
667: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
668: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);
669: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
670: END IF;
671:
672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 669: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);

665: ,x_adjv_rec =>x_adjv_rec);
666:
667: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
668: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);
669: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
670: END IF;
671:
672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
673: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

Line 676: iex_debug_pub.logmessage('Error' ||l_message);

672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
673: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
674: -- IF PG_DEBUG <11 THEN
675: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
676: iex_debug_pub.logmessage('Error' ||l_message);
677: END IF;
678: wf_engine.SetItemAttrText(itemtype => itemtype,
679: itemkey => itemkey,
680: aname => 'ERROR_MESSAGE',

Line 714: iex_debug_pub.logmessage ('Error in retreiving Code combination ');

710:
711: IF l_CODE_COMBINATION_ID IS NULL THEN
712: -- IF PG_DEBUG < 11 THEN
713: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
714: iex_debug_pub.logmessage ('Error in retreiving Code combination ');
715: END IF;
716:
717: select contract_number into l_contract_number
718: from okc_k_headers_b

Line 726: iex_debug_pub.logmessage('Error' ||l_message);

722: fnd_message.set_token('CONTRACT_NUMBER', l_contract_number);
723: fnd_msg_pub.add;
724: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
725: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
726: iex_debug_pub.logmessage('Error' ||l_message);
727: END IF;
728: wf_engine.SetItemAttrText(itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'ERROR_MESSAGE',

Line 741: iex_debug_pub.logmessage ('Code combination' ||l_ajlv_rec.CODE_COMBINATION_ID );

737: l_ajlv_rec.CODE_COMBINATION_ID := l_CODE_COMBINATION_ID;
738: l_code_combination_id := null;
739:
740: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
741: iex_debug_pub.logmessage ('Code combination' ||l_ajlv_rec.CODE_COMBINATION_ID );
742: END IF;
743:
744: --set error message,so this will be prefixed before the
745: --actual message, so it makes more sense than displaying an

Line 764: iex_debug_pub.logmessage('Error' ||l_message);

760: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
761: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
762: -- IF PG_DEBUG <11 THEN
763: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
764: iex_debug_pub.logmessage('Error' ||l_message);
765: END IF;
766: wf_engine.SetItemAttrText(itemtype => itemtype,
767: itemkey => itemkey,
768: aname => 'ERROR_MESSAGE',

Line 776: iex_debug_pub.logmessage ('okl_txl_adjsts_lns status '

772: return;
773: ELSE
774: -- IF PG_DEBUG <11 THEN
775: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
776: iex_debug_pub.logmessage ('okl_txl_adjsts_lns status '
777: ||l_return_status || ' Id ' ||
778: x_ajlv_rec.id);
779: END IF;
780: FND_MSG_PUB.initialize;

Line 796: iex_debug_pub.logmessage ('Before calling Okl Api' ||'transaction id ' || i.transaction_id);

792: AddfailMsg( p_object => 'Adjustments ', p_operation => 'CREATE' );
793:
794: -- IF PG_DEBUG <11 THEN
795: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
796: iex_debug_pub.logmessage ('Before calling Okl Api' ||'transaction id ' || i.transaction_id);
797: END IF;
798:
799: -- Begin bug 8258156
800: -- mo_global.set_policy_context('S',7746);

Line 802: iex_debug_pub.logmessage ('Before calling Okl Api Org ID = ' || i.org_id);

798:
799: -- Begin bug 8258156
800: -- mo_global.set_policy_context('S',7746);
801: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
802: iex_debug_pub.logmessage ('Before calling Okl Api Org ID = ' || i.org_id);
803: END IF;
804:
805: mo_global.set_policy_context('S',i.org_id);
806: -- End bug 8258156

Line 821: iex_debug_pub.logmessage ('After calling Okl Api and status'||l_return_status);

817: ,x_msg_data => l_msg_data);
818:
819: -- IF PG_DEBUG <11 THEN
820: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
821: iex_debug_pub.logmessage ('After calling Okl Api and status'||l_return_status);
822: END IF;
823:
824: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
825: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

Line 828: iex_debug_pub.logmessage('Error' ||l_message);

824: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
825: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
826: -- IF PG_DEBUG <11 THEN
827: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
828: iex_debug_pub.logmessage('Error' ||l_message);
829: END IF;
830: wf_engine.SetItemAttrText(itemtype => itemtype,
831: itemkey => itemkey,
832: aname => 'ERROR_MESSAGE',

Line 840: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);

836: return;
837: ELSE
838: FND_MSG_PUB.initialize;
839: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
840: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);
841: end if;
842: END IF;
843:
844: --else adjustment created and update iex_writeoff_objects

Line 854: iex_debug_pub.logmessage('Adjust ment ID is null ');

850: l_writeoff_obj_rec.writeoff_status :='A';
851: else
852: -- IF PG_DEBUG < 11 THEN
853: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
854: iex_debug_pub.logmessage('Adjust ment ID is null ');
855: END IF;
856:
857: AddfailMsg(p_object => 'Adjustments ',
858: p_operation => 'CREATE' );

Line 883: iex_debug_pub.logmessage('Error' ||l_message);

879: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
880: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
881: -- IF PG_DEBUG <11 THEN
882: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
883: iex_debug_pub.logmessage('Error' ||l_message);
884: END IF;
885: wf_engine.SetItemAttrText(itemtype => itemtype,
886: itemkey => itemkey,
887: aname => 'ERROR_MESSAGE',

Line 896: iex_debug_pub.logmessage('Finished updating iex_writeoffobjects');

892: ELSE
893: FND_MSG_PUB.initialize;
894: -- IF PG_DEBUG <11 THEN
895: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
896: iex_debug_pub.logmessage('Finished updating iex_writeoffobjects');
897: END IF;
898:
899: END IF;
900:

Line 927: iex_debug_pub.logmessage('Error' ||l_message);

923: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
924: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
925: -- IF PG_DEBUG <11 THEN
926: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
927: iex_debug_pub.logmessage('Error' ||l_message);
928: END IF;
929: wf_engine.SetItemAttrText(itemtype => itemtype,
930: itemkey => itemkey,
931: aname => 'ERROR_MESSAGE',

Line 939: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number

935: return;
936: ELSE
937: FND_MSG_PUB.initialize;
938: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
939: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
940: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id||
941: 'in approve writeoff procedure');
942: END IF;
943:

Line 951: iex_debug_pub.logmessage('l_object_id ' || l_object_id|| 'l_request_id '|| l_request_id );

947: termination notification
948: */
949: If l_object_type ='CONTRACT' THEN
950: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
951: iex_debug_pub.logmessage('l_object_id ' || l_object_id|| 'l_request_id '|| l_request_id );
952: end if;
953: -- iex_test_pub.logmessage('l_object_id ' || l_object_id||
954: -- 'l_request_id '|| l_request_id );
955: invoke_asset_mgr_wf(p_object_id => l_object_id

Line 965: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);

961: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
962: Get_Messages1 (l_msg_count,l_message);
963: -- IF PG_DEBUG < 11 THEN
964: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
965: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);
966: END IF;
967:
968: wf_engine.SetItemAttrText(itemtype => itemtype,
969: itemkey => itemkey,

Line 988: iex_debug_pub.logmessage('Error ' ||l_message);

984: WHEN FND_API.G_EXC_ERROR THEN
985: --resultout := wf_engine.eng_completed ||':'||wf_no;
986: -- IF PG_DEBUG < 11 THEN
987: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
988: iex_debug_pub.logmessage('Error ' ||l_message);
989: END IF;
990:
991: wf_core.context('IEX_WRITEOFFOBJ_PUB',
992: 'approve_writeoffs',

Line 1003: iex_debug_pub.logmessage('Error WHEN OTHERE' ||sqlerrm);

999: when others then
1000: --resultout := wf_engine.eng_completed ||':'||wf_no;
1001: -- IF PG_DEBUG < 11 THEN
1002: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1003: iex_debug_pub.logmessage('Error WHEN OTHERE' ||sqlerrm);
1004: END IF;
1005: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1006: 'approve_writeoffs',
1007: itemtype,

Line 1066: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');

1062: if funcmode <> 'RUN' then
1063: result := wf_engine.eng_null;
1064: return;
1065: end if;
1066: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');
1067: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'WRITEOFF_ID');
1070:

Line 1106: iex_debug_pub.logmessage('Error' ||l_message);

1102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1103: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1104: -- IF PG_DEBUG <11 THEN
1105: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1106: iex_debug_pub.logmessage('Error' ||l_message);
1107: END IF;
1108: wf_engine.SetItemAttrText(itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'ERROR_MESSAGE',

Line 1145: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);

1141: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1142: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1143: -- IF PG_DEBUG <11 THEN
1144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1145: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);
1146: END IF;
1147:
1148: wf_engine.SetItemAttrText(itemtype => itemtype,
1149: itemkey => itemkey,