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_MOD_SYNC_PROCESS_PVT dependencies on PO_MOD_SYNC_PROCESS_PVT

Line 1: PACKAGE BODY PO_MOD_SYNC_PROCESS_PVT AS

1: PACKAGE BODY PO_MOD_SYNC_PROCESS_PVT AS
2: /* $Header: PO_MOD_SYNC_PROCESS_PVT.plb 120.20.12020000.5 2013/04/18 04:37:36 amalick ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_MOD_SYNC_PROCESS_PVT');

Line 2: /* $Header: PO_MOD_SYNC_PROCESS_PVT.plb 120.20.12020000.5 2013/04/18 04:37:36 amalick ship $ */

1: PACKAGE BODY PO_MOD_SYNC_PROCESS_PVT AS
2: /* $Header: PO_MOD_SYNC_PROCESS_PVT.plb 120.20.12020000.5 2013/04/18 04:37:36 amalick ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_MOD_SYNC_PROCESS_PVT');
6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 5: PO_LOG.get_package_base('PO_MOD_SYNC_PROCESS_PVT');

1: PACKAGE BODY PO_MOD_SYNC_PROCESS_PVT AS
2: /* $Header: PO_MOD_SYNC_PROCESS_PVT.plb 120.20.12020000.5 2013/04/18 04:37:36 amalick ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_MOD_SYNC_PROCESS_PVT');
6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DRAFT_MERGE_PKG';
8: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
9:

Line 4753: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 01';

4749: l_base_rev_num PO_HEADERS_ALL.revision_num%TYPE;
4750: l_mod_rev_num PO_HEADERS_ALL.revision_num%TYPE;
4751: BEGIN
4752:
4753: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 01';
4754:
4755: g_wf_item_type := itemtype;
4756: g_wf_item_key := itemkey;
4757:

Line 4855: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 02'||resultout;

4851: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
4852: itemkey => itemkey,
4853: aname => 'ONLINE_REPORT_TEXT',
4854: avalue => l_errormessage);
4855: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 02'||resultout;
4856: IF (g_po_wf_debug = 'Y') THEN
4857: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4858: END IF;
4859:

Line 4966: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.ACQUIRE_SYNC_SGD_LOCK: 01';

4962: PRAGMA AUTONOMOUS_TRANSACTION ;
4963:
4964: BEGIN
4965:
4966: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.ACQUIRE_SYNC_SGD_LOCK: 01';
4967:
4968: IF (g_po_wf_debug = 'Y') THEN
4969: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4970: END IF;

Line 4979: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.ACQUIRE_SYNC_SGD_LOCK: l_draft_id: '||l_draft_id||', l_po_header_id: '||l_po_header_id||', l_doc_sub_type: '||l_doc_sub_type||', l_doc_type: '||l_doc_type;

4975: INTO l_po_header_id
4976: FROM po_drafts
4977: WHERE draft_id = l_draft_id;
4978:
4979: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.ACQUIRE_SYNC_SGD_LOCK: l_draft_id: '||l_draft_id||', l_po_header_id: '||l_po_header_id||', l_doc_sub_type: '||l_doc_sub_type||', l_doc_type: '||l_doc_type;
4980:
4981:
4982: IF (g_po_wf_debug = 'Y') THEN
4983: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 5038: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Draft_id: ' || l_draft_id;

5034: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,
5035: itemkey => itemkey,
5036: aname => 'DRAFT_ID');
5037:
5038: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Draft_id: ' || l_draft_id;
5039:
5040: IF (g_po_wf_debug = 'Y') THEN
5041: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5042: END IF;

Line 5060: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: in no data found exception';

5056:
5057: EXCEPTION
5058: WHEN No_Data_Found THEN
5059: IF (g_po_wf_debug = 'Y') THEN
5060: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: in no data found exception';
5061: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5062: END IF;
5063: END;
5064:

Line 5066: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE value is : '|| l_is_lock_available;

5062: END IF;
5063: END;
5064:
5065: IF (g_po_wf_debug = 'Y') THEN
5066: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE value is : '|| l_is_lock_available;
5067: END IF;
5068:
5069: resultout := wf_engine.eng_completed || ':' || l_is_lock_available;
5070:

Line 5073: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Exception';

5069: resultout := wf_engine.eng_completed || ':' || l_is_lock_available;
5070:
5071: EXCEPTION
5072: WHEN OTHERS THEN
5073: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Exception';
5074: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5075: RAISE;
5076: END;
5077:

Line 5114: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Draft_id: '

5110: SELECT revision_num INTO l_draft_rev_num FROM po_headers_draft_all WHERE po_header_id = l_po_header_id AND draft_id = l_draft_id;
5111: SELECT revision_num INTO l_header_base_rev_num FROM po_headers_all WHERE po_header_id = l_po_header_id;
5112: SELECT revision_num INTO draft_revision_num FROM po_drafts WHERE draft_id = l_draft_id;
5113:
5114: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Draft_id: '
5115: || l_draft_id || 'l_draft_rev_num : '|| l_draft_rev_num || 'l_header_base_rev_num '|| l_header_base_rev_num || 'draft_revision_num '|| draft_revision_num;
5116:
5117: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5118:

Line 5126: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED value is '|| l_is_sgd_generation_req ;

5122: l_is_sgd_generation_req := 'Y';
5123: END IF;
5124:
5125: resultout := wf_engine.eng_completed || ':' || l_is_sgd_generation_req;
5126: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED value is '|| l_is_sgd_generation_req ;
5127: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5128:
5129: EXCEPTION
5130: WHEN No_Data_Found THEN

Line 5131: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: in no data found exception';

5127: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5128:
5129: EXCEPTION
5130: WHEN No_Data_Found THEN
5131: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: in no data found exception';
5132: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5133: WHEN OTHERS THEN
5134: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Exception';
5135: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

Line 5134: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Exception';

5130: WHEN No_Data_Found THEN
5131: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: in no data found exception';
5132: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5133: WHEN OTHERS THEN
5134: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Exception';
5135: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5136: RAISE;
5137: END;
5138:

Line 5167: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: 01';

5163: l_lang_code fnd_languages.language_code%TYPE;
5164: l_application_name VARCHAR(2):= 'PO';
5165: BEGIN
5166:
5167: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: 01';
5168: IF (g_po_wf_debug = 'Y') THEN
5169: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5170: END IF;
5171:

Line 5191: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: l_draft_id: '||l_draft_id||', l_po_header_id: '||

5187: aname => 'ORG_ID');
5188:
5189: SELECT revision_num into l_revision_number FROM po_headers_all WHERE po_header_id = l_po_header_id;
5190:
5191: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: l_draft_id: '||l_draft_id||', l_po_header_id: '||
5192: l_po_header_id||', l_doc_sub_type: '||l_doc_sub_type||', l_doc_type: '||l_doc_type ||'l_org_id :'|| l_org_id ||
5193: 'l_revision_number '|| l_revision_number;
5194:
5195: IF (g_po_wf_debug = 'Y') THEN

Line 5227: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: : Request id is - '|| l_request_id;

5223: argument11 =>l_doc_sub_type,
5224: argument12 =>l_application_name );
5225:
5226:
5227: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: : Request id is - '|| l_request_id;
5228:
5229: IF (g_po_wf_debug = 'Y') THEN
5230: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5231: END IF;

Line 5243: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: Error: '||sqlerrm;

5239: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5240:
5241: EXCEPTION
5242: WHEN OTHERS THEN
5243: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: Error: '||sqlerrm;
5244: IF (g_po_wf_debug = 'Y') THEN
5245: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5246: END IF;
5247: resultout := wf_engine.eng_completed || ':' || '';

Line 5289: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Draft_id: '

5285: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,
5286: itemkey => itemkey,
5287: aname => 'DRAFT_ID');
5288:
5289: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Draft_id: '
5290: || l_draft_id;
5291:
5292: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5293:

Line 5306: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: No Of rows deleted from po_entity_locks table : ' || SQL%ROWCOUNT;

5302: WHERE lock_by_draft_id = l_draft_id
5303: AND entity_pk1 = l_po_header_id
5304: AND entity_name = G_MOD_SYNC_LOCK;
5305:
5306: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: No Of rows deleted from po_entity_locks table : ' || SQL%ROWCOUNT;
5307: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5308:
5309: FOR item_key IN waiting_process_wf_keys(l_draft_id) LOOP
5310: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Item keys of waiting process : ' || item_key.item_key;

Line 5310: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Item keys of waiting process : ' || item_key.item_key;

5306: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: No Of rows deleted from po_entity_locks table : ' || SQL%ROWCOUNT;
5307: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5308:
5309: FOR item_key IN waiting_process_wf_keys(l_draft_id) LOOP
5310: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Item keys of waiting process : ' || item_key.item_key;
5311: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5312: --Execute complete activity on these process to resume
5313: wf_engine.CompleteActivity(x_itemtype,item_key.item_key,'WAIT_FOR_LOCK_TO_BE_RELEASED','ACTIVITY_PERFORMED');
5314: END LOOP;

Line 5320: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: in no data found exception';

5316: COMMIT;
5317:
5318: EXCEPTION
5319: WHEN No_Data_Found THEN
5320: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: in no data found exception';
5321: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5322: END;
5323:
5324: EXCEPTION

Line 5326: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Exception';

5322: END;
5323:
5324: EXCEPTION
5325: WHEN OTHERS THEN
5326: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Exception';
5327: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5328: RAISE;
5329: END RELEASE_SYNC_SGD_LOCK;
5330: