DBA Data[Home] [Help]

APPS.PO_AME_WF_PVT dependencies on PO_DEBUG

Line 10: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

6: g_next_approvers ame_util.approversTable2;
7: g_production_Indexes ame_util.idList;
8: g_variable_Names ame_util.stringList;
9: g_variable_Values ame_util.stringList;
10: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
11: g_pkg_name CONSTANT VARCHAR2(20) := 'PO_AME_WF_PVT';
12: g_module_prefix CONSTANT VARCHAR2(30) := 'po.plsql.' || g_pkg_name||'.';
13:
14: FUNCTION position_has_valid_approvers(

Line 4456: PO_DEBUG.debug_stmt

4452:
4453: if (wf_rec.end_date is null) then
4454:
4455: IF g_debug_stmt THEN
4456: PO_DEBUG.debug_stmt
4457: (p_log_head => l_log_head,
4458: p_token => l_progress,
4459: p_message => 'Aborting workflow : ' || wf_rec.item_type ||
4460: ' - ' || wf_rec.item_key);

Line 4477: PO_DEBUG.debug_stmt

4473: WHEN OTHERS THEN
4474: ROLLBACK;
4475: x_return_message := 'Exception ' || SQLERRM || ' in abort_workflow';
4476: IF g_debug_stmt THEN
4477: PO_DEBUG.debug_stmt
4478: (p_log_head => l_log_head,
4479: p_token => l_progress,
4480: p_message => x_return_message);
4481: END IF;

Line 4518: PO_DEBUG.debug_stmt

4514:
4515: BEGIN
4516: l_progress := '000';
4517: IF g_debug_stmt THEN
4518: PO_DEBUG.debug_stmt
4519: (p_log_head => l_log_head,
4520: p_token => l_progress,
4521: p_message => 'Updating authorization status of ' || p_document_id);
4522: END IF;

Line 4549: PO_DEBUG.debug_stmt

4545: WHEN OTHERS THEN
4546: ROLLBACK;
4547: x_return_message := 'Exception ' || SQLERRM || ' in reset_authorization_status';
4548: IF g_debug_stmt THEN
4549: PO_DEBUG.debug_stmt
4550: (p_log_head => l_log_head,
4551: p_token => l_progress,
4552: p_message => x_return_message);
4553: END IF;

Line 4632: PO_DEBUG.debug_stmt (p_log_head => l_log_head,

4628: aname=> 'EDIT_DOC_URL',
4629: avalue =>p_edit_po_url);
4630:
4631: IF g_debug_stmt THEN
4632: PO_DEBUG.debug_stmt (p_log_head => l_log_head,
4633: p_token => l_progress,
4634: p_message => 'Sending notification ' || l_notification_id ||
4635: ' to ' || p_role);
4636: END IF;

Line 4644: PO_DEBUG.debug_stmt

4640:
4641: WHEN OTHERS THEN
4642: ROLLBACK;
4643: IF g_debug_stmt THEN
4644: PO_DEBUG.debug_stmt
4645: (p_log_head => l_log_head,
4646: p_token => l_progress,
4647: p_message => 'Exception ' || SQLERRM || ' while sending notification to ' || p_role);
4648: END IF;

Line 4712: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4708: BEGIN
4709:
4710: l_progress := '000';
4711: IF g_debug_stmt THEN
4712: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4713: PO_DEBUG.debug_stmt
4714: (p_log_head => l_log_head,
4715: p_token =>l_progress,
4716: p_message => 'In notify_abt_withdrawal');

Line 4713: PO_DEBUG.debug_stmt

4709:
4710: l_progress := '000';
4711: IF g_debug_stmt THEN
4712: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4713: PO_DEBUG.debug_stmt
4714: (p_log_head => l_log_head,
4715: p_token =>l_progress,
4716: p_message => 'In notify_abt_withdrawal');
4717:

Line 4744: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4740: PO_REQAPPROVAL_INIT1.get_user_name(emp_rc.employee_id , l_emp_user_name, l_emp_disp_name);
4741:
4742: l_progress := '003';
4743: IF g_debug_stmt THEN
4744: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4745: PO_DEBUG.debug_stmt
4746: (p_log_head => l_log_head,
4747: p_token => l_progress,
4748: p_message => 'Calling send withdraw notifictaion to ' || l_emp_user_name );

Line 4745: PO_DEBUG.debug_stmt

4741:
4742: l_progress := '003';
4743: IF g_debug_stmt THEN
4744: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4745: PO_DEBUG.debug_stmt
4746: (p_log_head => l_log_head,
4747: p_token => l_progress,
4748: p_message => 'Calling send withdraw notifictaion to ' || l_emp_user_name );
4749: END IF;

Line 4771: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4767: FROM po_acceptances
4768: WHERE po_header_id=p_document_id;
4769:
4770: IF g_debug_stmt THEN
4771: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4772: PO_DEBUG.debug_stmt
4773: (p_log_head => l_log_head,
4774: p_token => l_progress,
4775: p_message => 'l_acceptance_id ' || l_acceptance_id );

Line 4772: PO_DEBUG.debug_stmt

4768: WHERE po_header_id=p_document_id;
4769:
4770: IF g_debug_stmt THEN
4771: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4772: PO_DEBUG.debug_stmt
4773: (p_log_head => l_log_head,
4774: p_token => l_progress,
4775: p_message => 'l_acceptance_id ' || l_acceptance_id );
4776: END IF;

Line 4789: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4785:
4786: l_progress := '005';
4787:
4788: IF g_debug_stmt THEN
4789: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4790: PO_DEBUG.debug_stmt
4791: (p_log_head => l_log_head,
4792: p_token => l_progress,
4793: p_message => 'l_supp_contact_user_name ' || l_supp_contact_user_name );

Line 4790: PO_DEBUG.debug_stmt

4786: l_progress := '005';
4787:
4788: IF g_debug_stmt THEN
4789: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4790: PO_DEBUG.debug_stmt
4791: (p_log_head => l_log_head,
4792: p_token => l_progress,
4793: p_message => 'l_supp_contact_user_name ' || l_supp_contact_user_name );
4794: END IF;

Line 4810: PO_DEBUG.debug_stmt (p_log_head => l_log_head,

4806:
4807: EXCEPTION
4808: WHEN NO_DATA_FOUND THEN
4809: IF g_debug_stmt THEN
4810: PO_DEBUG.debug_stmt (p_log_head => l_log_head,
4811: p_token => l_progress,
4812: p_message => 'Need not send notifictaion to Supplier');
4813: END IF;
4814: END;

Line 4820: PO_DEBUG.debug_stmt

4816: EXCEPTION
4817:
4818: WHEN OTHERS THEN
4819: IF g_debug_stmt THEN
4820: PO_DEBUG.debug_stmt
4821: (p_log_head => l_log_head,
4822: p_token => l_progress,
4823: p_message => 'Exception ' || SQLERRM || ' in notify_abt_withdrawal');
4824: END IF;

Line 4878: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4874: BEGIN
4875:
4876: l_progress := '000';
4877: IF g_debug_stmt THEN
4878: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4879: PO_DEBUG.debug_stmt
4880: (p_log_head => l_log_head,
4881: p_token => l_progress,
4882: p_message => 'document_type: ' || p_document_type ||

Line 4879: PO_DEBUG.debug_stmt

4875:
4876: l_progress := '000';
4877: IF g_debug_stmt THEN
4878: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4879: PO_DEBUG.debug_stmt
4880: (p_log_head => l_log_head,
4881: p_token => l_progress,
4882: p_message => 'document_type: ' || p_document_type ||
4883: ' document_sub_type ' || p_document_sub_type

Line 4906: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4902:
4903: l_progress := '001';
4904:
4905: IF g_debug_stmt THEN
4906: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4907: PO_DEBUG.debug_stmt
4908: (p_log_head => l_log_head,
4909: p_token => l_progress,
4910: p_message => 'itemkey is ' || l_item_key);

Line 4907: PO_DEBUG.debug_stmt

4903: l_progress := '001';
4904:
4905: IF g_debug_stmt THEN
4906: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4907: PO_DEBUG.debug_stmt
4908: (p_log_head => l_log_head,
4909: p_token => l_progress,
4910: p_message => 'itemkey is ' || l_item_key);
4911: END IF;

Line 4918: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4914:
4915: l_progress := '002';
4916:
4917: IF g_debug_stmt THEN
4918: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4919: PO_DEBUG.debug_stmt
4920: (p_log_head => l_log_head,
4921: p_token => l_progress,
4922: p_message => 'Current user is ' || l_current_user_name);

Line 4919: PO_DEBUG.debug_stmt

4915: l_progress := '002';
4916:
4917: IF g_debug_stmt THEN
4918: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4919: PO_DEBUG.debug_stmt
4920: (p_log_head => l_log_head,
4921: p_token => l_progress,
4922: p_message => 'Current user is ' || l_current_user_name);
4923: END IF;

Line 4947: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4943: x_return_message => x_return_message);
4944:
4945: l_progress := '003';
4946: IF g_debug_stmt THEN
4947: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4948: PO_DEBUG.debug_stmt
4949: (p_log_head => l_log_head,
4950: p_token => l_progress,
4951: p_message => 'Successfully aborted workflow' );

Line 4948: PO_DEBUG.debug_stmt

4944:
4945: l_progress := '003';
4946: IF g_debug_stmt THEN
4947: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4948: PO_DEBUG.debug_stmt
4949: (p_log_head => l_log_head,
4950: p_token => l_progress,
4951: p_message => 'Successfully aborted workflow' );
4952: END IF;

Line 4962: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4958: x_return_message => x_return_message);
4959:
4960: l_progress := '004';
4961: IF g_debug_stmt THEN
4962: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4963: PO_DEBUG.debug_stmt
4964: (p_log_head => l_log_head,
4965: p_token => l_progress,
4966: p_message => 'Authorization status update complete' );

Line 4963: PO_DEBUG.debug_stmt

4959:
4960: l_progress := '004';
4961: IF g_debug_stmt THEN
4962: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4963: PO_DEBUG.debug_stmt
4964: (p_log_head => l_log_head,
4965: p_token => l_progress,
4966: p_message => 'Authorization status update complete' );
4967: END IF;

Line 4981: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4977: p_current_approver => NULL);
4978:
4979: l_progress := '005';
4980: IF g_debug_stmt THEN
4981: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4982: PO_DEBUG.debug_stmt
4983: (p_log_head => l_log_head,
4984: p_token => l_progress,
4985: p_message => 'Updated the existing NULL actions with NO ACTION');

Line 4982: PO_DEBUG.debug_stmt

4978:
4979: l_progress := '005';
4980: IF g_debug_stmt THEN
4981: PO_DEBUG.debug_begin(p_log_head => l_log_head );
4982: PO_DEBUG.debug_stmt
4983: (p_log_head => l_log_head,
4984: p_token => l_progress,
4985: p_message => 'Updated the existing NULL actions with NO ACTION');
4986: END IF;

Line 5001: PO_DEBUG.debug_begin(p_log_head => l_log_head );

4997: p_note => p_note);
4998:
4999: l_progress := '006';
5000: IF g_debug_stmt THEN
5001: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5002: PO_DEBUG.debug_stmt
5003: (p_log_head => l_log_head,
5004: p_token => l_progress,
5005: p_message => 'Inserted WITHDRAW action in action history');

Line 5002: PO_DEBUG.debug_stmt

4998:
4999: l_progress := '006';
5000: IF g_debug_stmt THEN
5001: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5002: PO_DEBUG.debug_stmt
5003: (p_log_head => l_log_head,
5004: p_token => l_progress,
5005: p_message => 'Inserted WITHDRAW action in action history');
5006: END IF;

Line 5022: PO_DEBUG.debug_begin(p_log_head => l_log_head );

5018: END;
5019:
5020: l_progress := '007';
5021: IF g_debug_stmt THEN
5022: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5023: PO_DEBUG.debug_stmt
5024: (p_log_head => l_log_head,
5025: p_token => l_progress,
5026: p_message => 'l_send_notf_flag : ' || l_send_notf_flag);

Line 5023: PO_DEBUG.debug_stmt

5019:
5020: l_progress := '007';
5021: IF g_debug_stmt THEN
5022: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5023: PO_DEBUG.debug_stmt
5024: (p_log_head => l_log_head,
5025: p_token => l_progress,
5026: p_message => 'l_send_notf_flag : ' || l_send_notf_flag);
5027: END IF;

Line 5040: PO_DEBUG.debug_begin(p_log_head => l_log_head );

5036: p_edit_po_url => l_edit_po_url);
5037:
5038: l_progress := '008';
5039: IF g_debug_stmt THEN
5040: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5041: PO_DEBUG.debug_stmt
5042: (p_log_head => l_log_head,
5043: p_token => l_progress,
5044: p_message => 'Notified all approvers');

Line 5041: PO_DEBUG.debug_stmt

5037:
5038: l_progress := '008';
5039: IF g_debug_stmt THEN
5040: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5041: PO_DEBUG.debug_stmt
5042: (p_log_head => l_log_head,
5043: p_token => l_progress,
5044: p_message => 'Notified all approvers');
5045: END IF;

Line 5059: PO_DEBUG.debug_begin(p_log_head => l_log_head );

5055: FND_MESSAGE.set_name('PO', 'PO_UNABLE_TO_WITHDRAW');
5056: FND_MESSAGE.set_token('ERR_MESSAGE', x_return_message);
5057: x_return_message := FND_MESSAGE.get;
5058: IF g_debug_stmt THEN
5059: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5060: PO_DEBUG.debug_stmt
5061: (p_log_head => l_log_head,
5062: p_token => l_progress,
5063: p_message => x_return_message);

Line 5060: PO_DEBUG.debug_stmt

5056: FND_MESSAGE.set_token('ERR_MESSAGE', x_return_message);
5057: x_return_message := FND_MESSAGE.get;
5058: IF g_debug_stmt THEN
5059: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5060: PO_DEBUG.debug_stmt
5061: (p_log_head => l_log_head,
5062: p_token => l_progress,
5063: p_message => x_return_message);
5064: END IF;

Line 5265: PO_DEBUG.debug_begin(p_log_head => l_log_head );

5261: l_log_head := g_module_prefix || 'get_current_future_approvers';
5262:
5263: l_progress := '000';
5264: IF g_debug_stmt THEN
5265: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5266: PO_DEBUG.debug_stmt
5267: (p_log_head => l_log_head,
5268: p_token => l_progress,
5269: p_message => 'transactionType: ' || transactionType ||

Line 5266: PO_DEBUG.debug_stmt

5262:
5263: l_progress := '000';
5264: IF g_debug_stmt THEN
5265: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5266: PO_DEBUG.debug_stmt
5267: (p_log_head => l_log_head,
5268: p_token => l_progress,
5269: p_message => 'transactionType: ' || transactionType ||
5270: ' transactionId ' || transactionId);

Line 5443: PO_DEBUG.debug_begin(p_log_head => l_log_head );

5439:
5440: EXCEPTION
5441: WHEN OTHERS THEN
5442: IF g_debug_stmt THEN
5443: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5444: PO_DEBUG.debug_stmt
5445: (p_log_head => l_log_head,
5446: p_token => l_progress,
5447: p_message => 'Exception ' || sqlerrm);

Line 5444: PO_DEBUG.debug_stmt

5440: EXCEPTION
5441: WHEN OTHERS THEN
5442: IF g_debug_stmt THEN
5443: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5444: PO_DEBUG.debug_stmt
5445: (p_log_head => l_log_head,
5446: p_token => l_progress,
5447: p_message => 'Exception ' || sqlerrm);
5448: END IF;

Line 5468: PO_DEBUG.debug_begin(p_log_head => l_log_head );

5464:
5465: WHEN OTHERS THEN
5466:
5467: IF g_debug_stmt THEN
5468: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5469: PO_DEBUG.debug_stmt
5470: (p_log_head => l_log_head,
5471: p_token => l_progress,
5472: p_message => 'Exception ' || sqlerrm);

Line 5469: PO_DEBUG.debug_stmt

5465: WHEN OTHERS THEN
5466:
5467: IF g_debug_stmt THEN
5468: PO_DEBUG.debug_begin(p_log_head => l_log_head );
5469: PO_DEBUG.debug_stmt
5470: (p_log_head => l_log_head,
5471: p_token => l_progress,
5472: p_message => 'Exception ' || sqlerrm);
5473: END IF;