214: FND_MSG_PUB.Initialize;
215: END IF;
216:
217: -- get the Enigma user and responsibility, and call apps_initialize
218: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
219: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
220: IF (l_log_statement >= l_log_current_level) THEN
221: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
222: END IF;
215: END IF;
216:
217: -- get the Enigma user and responsibility, and call apps_initialize
218: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
219: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
220: IF (l_log_statement >= l_log_current_level) THEN
221: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
222: END IF;
223: BEGIN
229: END IF;
230: END;
231:
232: -- get the org id from the new profile
233: l_org_id := FND_PROFILE.VALUE('AHL_ENIGMA_ITEM_ORG');
234:
235: IF (l_log_statement >= l_log_current_level) THEN
236: FND_LOG.string(l_log_statement, l_full_name, 'l_org_id = '||l_org_id);
237: END IF;
743: FND_MSG_PUB.Initialize;
744: END IF;
745:
746: -- get the Enigma user and responsibility, and call apps_initialize
747: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
748: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
749: IF (l_log_statement >= l_log_current_level) THEN
750: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
751: END IF;
744: END IF;
745:
746: -- get the Enigma user and responsibility, and call apps_initialize
747: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
748: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
749: IF (l_log_statement >= l_log_current_level) THEN
750: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
751: END IF;
752: BEGIN
1105: FND_MSG_PUB.Initialize;
1106: END IF;
1107:
1108: -- get the Enigma user and responsibility, and call apps_initialize
1109: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
1110: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
1111: IF (l_log_statement >= l_log_current_level) THEN
1112: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
1113: END IF;
1106: END IF;
1107:
1108: -- get the Enigma user and responsibility, and call apps_initialize
1109: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
1110: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
1111: IF (l_log_statement >= l_log_current_level) THEN
1112: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
1113: END IF;
1114: BEGIN
1120: END IF;
1121: END;
1122:
1123: -- get the org id from the new profile
1124: l_org_id := FND_PROFILE.VALUE('AHL_ENIGMA_ITEM_ORG');
1125:
1126: IF (l_log_statement >= l_log_current_level) THEN
1127: FND_LOG.string(l_log_statement, l_full_name, 'l_org_id = '||l_org_id);
1128: END IF;
1544: -- initialize return status to success
1545: retcode := 0;
1546:
1547: -- fetch the BPEL IPC process AhlProcessIPCReports URL from the profile 'AHL: BPEL IPC Process (AhlProcessIPCReports) URL'
1548: l_process_URL := FND_PROFILE.VALUE('AHL_ENIGMA_BPEL_IPC_URL');
1549:
1550: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Prcoess URL: '||l_process_URL);
1551: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1552: