DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on FND_GLOBAL

Line 134: p_user_id => fnd_global.user_id,

130: p_init_msg_list => FND_API.G_FALSE,
131: p_contract_id => p_contract_id,
132: p_contract_version => p_contract_version,
133: p_status_code => G_STATUS_PENDING_APPROVAL,
134: p_user_id => fnd_global.user_id,
135: p_note => NULL,
136: x_msg_data => x_msg_data,
137: x_msg_count => x_msg_count,
138: x_return_status => x_return_status);

Line 164: p_user_id => fnd_global.user_id,

160: p_init_msg_list => FND_API.G_FALSE,
161: p_contract_id => p_contract_id,
162: p_contract_version => p_contract_version,
163: p_action_code => G_ACTION_SUBMITTED,
164: p_user_id => fnd_global.user_id,
165: p_note => NULL,
166: x_msg_data => x_msg_data,
167: x_msg_count => x_msg_count,
168: x_return_status => x_return_status);

Line 216: owner => fnd_global.user_name);

212: END IF;
213: WF_ENGINE.SetItemOwner (
214: itemtype => l_wf_name,
215: itemkey => l_wf_sequence,
216: owner => fnd_global.user_name);
217:
218:
219: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 237: avalue => fnd_global.user_name);

233: WF_ENGINE.SetItemAttrText (
234: itemtype => l_wf_name,
235: itemkey => l_wf_sequence,
236: aname => 'REQUESTER',
237: avalue => fnd_global.user_name);
238:
239: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
241: 'Calling WF_ENGINE.setitemattrnumber for CTX_USER_ID ' || fnd_global.user_id);

Line 241: 'Calling WF_ENGINE.setitemattrnumber for CTX_USER_ID ' || fnd_global.user_id);

237: avalue => fnd_global.user_name);
238:
239: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
241: 'Calling WF_ENGINE.setitemattrnumber for CTX_USER_ID ' || fnd_global.user_id);
242: END IF;
243:
244: WF_ENGINE.SetItemAttrNumber (
245: itemtype => l_wf_name,

Line 248: avalue => fnd_global.user_id);

244: WF_ENGINE.SetItemAttrNumber (
245: itemtype => l_wf_name,
246: itemkey => l_wf_sequence,
247: aname => 'CTX_USER_ID',
248: avalue => fnd_global.user_id);
249:
250: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
251: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
252: 'Calling WF_ENGINE.setitemattrnumber for CTX_APPL_ID ' || fnd_global.RESP_APPL_ID);

Line 252: 'Calling WF_ENGINE.setitemattrnumber for CTX_APPL_ID ' || fnd_global.RESP_APPL_ID);

248: avalue => fnd_global.user_id);
249:
250: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
251: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
252: 'Calling WF_ENGINE.setitemattrnumber for CTX_APPL_ID ' || fnd_global.RESP_APPL_ID);
253: END IF;
254: WF_ENGINE.SetItemAttrNumber (
255: itemtype => l_wf_name,
256: itemkey => l_wf_sequence,

Line 258: avalue => fnd_global.RESP_APPL_ID);

254: WF_ENGINE.SetItemAttrNumber (
255: itemtype => l_wf_name,
256: itemkey => l_wf_sequence,
257: aname => 'CTX_APPL_ID',
258: avalue => fnd_global.RESP_APPL_ID);
259:
260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
262: 'Calling WF_ENGINE.setitemattrnumber for CTX_RESP_ID ' || fnd_global.resp_id);

Line 262: 'Calling WF_ENGINE.setitemattrnumber for CTX_RESP_ID ' || fnd_global.resp_id);

258: avalue => fnd_global.RESP_APPL_ID);
259:
260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
262: 'Calling WF_ENGINE.setitemattrnumber for CTX_RESP_ID ' || fnd_global.resp_id);
263: END IF;
264: WF_ENGINE.SetItemAttrNumber (
265: itemtype => l_wf_name,
266: itemkey => l_wf_sequence,

Line 268: avalue => fnd_global.resp_id);

264: WF_ENGINE.SetItemAttrNumber (
265: itemtype => l_wf_name,
266: itemkey => l_wf_sequence,
267: aname => 'CTX_RESP_ID',
268: avalue => fnd_global.resp_id);
269:
270:
271: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
272: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2545: l_created_by := Fnd_Global.User_Id;

2541: -- Initialize API return status to success
2542: x_return_status := FND_API.G_RET_STS_SUCCESS;
2543: -- Populate who columns
2544: l_creation_date := Sysdate;
2545: l_created_by := Fnd_Global.User_Id;
2546: l_last_update_date := l_creation_date;
2547: l_last_updated_by := l_created_by;
2548: l_last_update_login := Fnd_Global.Login_Id;
2549:

Line 2548: l_last_update_login := Fnd_Global.Login_Id;

2544: l_creation_date := Sysdate;
2545: l_created_by := Fnd_Global.User_Id;
2546: l_last_update_date := l_creation_date;
2547: l_last_updated_by := l_created_by;
2548: l_last_update_login := Fnd_Global.Login_Id;
2549:
2550: FOR contact_rec IN contact_csr LOOP
2551: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2552: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2724: l_created_by := Fnd_Global.User_Id;

2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722: -- Populate who columns
2723: l_creation_date := Sysdate;
2724: l_created_by := Fnd_Global.User_Id;
2725: l_last_update_date := l_creation_date;
2726: l_last_updated_by := l_created_by;
2727: l_last_update_login := Fnd_Global.Login_Id;
2728:

Line 2727: l_last_update_login := Fnd_Global.Login_Id;

2723: l_creation_date := Sysdate;
2724: l_created_by := Fnd_Global.User_Id;
2725: l_last_update_date := l_creation_date;
2726: l_last_updated_by := l_created_by;
2727: l_last_update_login := Fnd_Global.Login_Id;
2728:
2729: FOR party_rec IN party_csr LOOP
2730: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2731: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2906: l_created_by := Fnd_Global.User_Id;

2902: x_return_status := FND_API.G_RET_STS_SUCCESS;
2903:
2904: -- Populate who columns
2905: l_creation_date := Sysdate;
2906: l_created_by := Fnd_Global.User_Id;
2907: l_last_update_date := l_creation_date;
2908: l_last_updated_by := l_created_by;
2909: l_last_update_login := Fnd_Global.Login_Id;
2910:

Line 2909: l_last_update_login := Fnd_Global.Login_Id;

2905: l_creation_date := Sysdate;
2906: l_created_by := Fnd_Global.User_Id;
2907: l_last_update_date := l_creation_date;
2908: l_last_updated_by := l_created_by;
2909: l_last_update_login := Fnd_Global.Login_Id;
2910:
2911: -- Get Contract type and version number columns
2912: -- Get effective dates and version of the contract.
2913: OPEN contract_csr;

Line 3768: l_created_by := Fnd_Global.User_Id;

3764: x_return_status := FND_API.G_RET_STS_SUCCESS;
3765:
3766: -- Populate who columns
3767: l_creation_date := Sysdate;
3768: l_created_by := Fnd_Global.User_Id;
3769: l_last_update_date := l_creation_date;
3770: l_last_updated_by := l_created_by;
3771: l_last_update_login := Fnd_Global.Login_Id;
3772:

Line 3771: l_last_update_login := Fnd_Global.Login_Id;

3767: l_creation_date := Sysdate;
3768: l_created_by := Fnd_Global.User_Id;
3769: l_last_update_date := l_creation_date;
3770: l_last_updated_by := l_created_by;
3771: l_last_update_login := Fnd_Global.Login_Id;
3772:
3773: -- Get Contract type and version number columns
3774: -- Get effective dates and version of the contract.
3775: OPEN contract_csr;

Line 4616: p_user_id => fnd_global.user_id,

4612: p_init_msg_list => FND_API.G_FALSE,
4613: p_contract_id => p_contract_id,
4614: p_contract_version => contract_rec.contract_version_num,
4615: p_status_code => G_STATUS_SIGNED,
4616: p_user_id => fnd_global.user_id,
4617: p_note => NULL,
4618: x_msg_data => x_msg_data,
4619: x_msg_count => x_msg_count,
4620: x_return_status => x_return_status);

Line 5051: p_user_id => fnd_global.user_id,

5047: p_init_msg_list => FND_API.G_FALSE,
5048: p_contract_id => p_contract_id,
5049: p_contract_version => l_contract_version,
5050: p_status_code => G_STATUS_PENDING_SIGNATURE,
5051: p_user_id => fnd_global.user_id,
5052: p_note => NULL,
5053: x_msg_data => x_msg_data,
5054: x_msg_count => x_msg_count,
5055: x_return_status => x_return_status);

Line 5083: p_user_id => fnd_global.user_id,

5079: p_contract_id => p_contract_id,
5080: p_sequence_id => NULL ,
5081: p_contract_version => contract_rec.contract_version_num,
5082: p_action_code => G_ACTION_SUBMITTED,
5083: p_user_id => fnd_global.user_id,
5084: p_note => NULL,
5085: x_msg_data => x_msg_data,
5086: x_msg_count => x_msg_count,
5087: x_return_status => x_return_status,

Line 5142: owner => fnd_global.user_name);

5138: END IF;
5139: WF_ENGINE.SetItemOwner (
5140: itemtype => l_wf_name,
5141: itemkey => l_wf_sequence,
5142: owner => fnd_global.user_name);
5143:
5144:
5145: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5146: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 5163: avalue => fnd_global.user_name);

5159: WF_ENGINE.SetItemAttrText (
5160: itemtype => l_wf_name,
5161: itemkey => l_wf_sequence,
5162: aname => 'REQUESTER',
5163: avalue => fnd_global.user_name);
5164:
5165: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5167: 'Calling WF_ENGINE.setitemattrnumber for CTX_USER_ID ' || fnd_global.user_id);

Line 5167: 'Calling WF_ENGINE.setitemattrnumber for CTX_USER_ID ' || fnd_global.user_id);

5163: avalue => fnd_global.user_name);
5164:
5165: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5167: 'Calling WF_ENGINE.setitemattrnumber for CTX_USER_ID ' || fnd_global.user_id);
5168: END IF;
5169:
5170: WF_ENGINE.SetItemAttrNumber (
5171: itemtype => l_wf_name,

Line 5174: avalue => fnd_global.user_id);

5170: WF_ENGINE.SetItemAttrNumber (
5171: itemtype => l_wf_name,
5172: itemkey => l_wf_sequence,
5173: aname => 'CTX_USER_ID',
5174: avalue => fnd_global.user_id);
5175:
5176: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5177: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5178: 'Calling WF_ENGINE.setitemattrnumber for CTX_APPL_ID ' || fnd_global.RESP_APPL_ID);

Line 5178: 'Calling WF_ENGINE.setitemattrnumber for CTX_APPL_ID ' || fnd_global.RESP_APPL_ID);

5174: avalue => fnd_global.user_id);
5175:
5176: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5177: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5178: 'Calling WF_ENGINE.setitemattrnumber for CTX_APPL_ID ' || fnd_global.RESP_APPL_ID);
5179: END IF;
5180: WF_ENGINE.SetItemAttrNumber (
5181: itemtype => l_wf_name,
5182: itemkey => l_wf_sequence,

Line 5184: avalue => fnd_global.RESP_APPL_ID);

5180: WF_ENGINE.SetItemAttrNumber (
5181: itemtype => l_wf_name,
5182: itemkey => l_wf_sequence,
5183: aname => 'CTX_APPL_ID',
5184: avalue => fnd_global.RESP_APPL_ID);
5185:
5186: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5188: 'Calling WF_ENGINE.setitemattrnumber for CTX_RESP_ID ' || fnd_global.resp_id);

Line 5188: 'Calling WF_ENGINE.setitemattrnumber for CTX_RESP_ID ' || fnd_global.resp_id);

5184: avalue => fnd_global.RESP_APPL_ID);
5185:
5186: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5188: 'Calling WF_ENGINE.setitemattrnumber for CTX_RESP_ID ' || fnd_global.resp_id);
5189: END IF;
5190: WF_ENGINE.SetItemAttrNumber (
5191: itemtype => l_wf_name,
5192: itemkey => l_wf_sequence,

Line 5194: avalue => fnd_global.resp_id);

5190: WF_ENGINE.SetItemAttrNumber (
5191: itemtype => l_wf_name,
5192: itemkey => l_wf_sequence,
5193: aname => 'CTX_RESP_ID',
5194: avalue => fnd_global.resp_id);
5195:
5196: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5197: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5198: 'Calling WF_ENGINE.startprocess');

Line 5430: p_user_id => fnd_global.user_id,

5426: p_init_msg_list => FND_API.G_FALSE,
5427: p_contract_id => p_contract_id,
5428: p_contract_version => contract_rec.contract_version_num,
5429: p_status_code => G_STATUS_TERMINATED,
5430: p_user_id => fnd_global.user_id,
5431: p_note => NULL,
5432: x_msg_data => x_msg_data,
5433: x_msg_count => x_msg_count,
5434: x_return_status => x_return_status);

Line 5888: owner => fnd_global.user_name);

5884: --set process owner
5885: wf_engine.SetItemOwner (
5886: itemtype => l_item_type,
5887: itemkey => l_item_key,
5888: owner => fnd_global.user_name);
5889:
5890: --set contracts role parameter
5891: wf_engine.SetItemAttrText (
5892: itemtype => l_item_type,

Line 6249: p_user_id => fnd_global.user_id,

6245: p_init_msg_list => FND_API.G_FALSE,
6246: p_contract_id => p_contract_id,
6247: p_contract_version => p_contract_version,
6248: p_status_code => G_STATUS_DRAFT,
6249: p_user_id => fnd_global.user_id,
6250: p_note => NULL,
6251: x_msg_data => x_msg_data,
6252: x_msg_count => x_msg_count,
6253: x_return_status => x_return_status);

Line 6280: p_user_id => fnd_global.user_id,

6276: p_init_msg_list => FND_API.G_FALSE,
6277: p_contract_id => p_contract_id,
6278: p_contract_version => p_contract_version,
6279: p_action_code => G_ACTION_ABORTED,
6280: p_user_id => fnd_global.user_id,
6281: p_note => NULL,
6282: x_msg_data => x_msg_data,
6283: x_msg_count => x_msg_count,
6284: x_return_status => x_return_status);