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.CS_WF_EVENT_PKG dependencies on FND_API

Line 289: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

285: *************************************************************************/
286:
287: PROCEDURE Raise_ServiceRequest_Event(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
290: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
291: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
292: p_Event_Code IN VARCHAR2,
293: p_Incident_Number IN VARCHAR2,

Line 290: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

286:
287: PROCEDURE Raise_ServiceRequest_Event(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
290: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
291: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
292: p_Event_Code IN VARCHAR2,
293: p_Incident_Number IN VARCHAR2,
294: p_USER_ID IN NUMBER DEFAULT FND_GLOBAL.USER_ID, -- p_last_updated_by from Update_ServiceREquest()

Line 291: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

287: PROCEDURE Raise_ServiceRequest_Event(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
290: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
291: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
292: p_Event_Code IN VARCHAR2,
293: p_Incident_Number IN VARCHAR2,
294: p_USER_ID IN NUMBER DEFAULT FND_GLOBAL.USER_ID, -- p_last_updated_by from Update_ServiceREquest()
295: p_RESP_ID IN NUMBER, -- p_resp_id from Update_ServiceREquest()

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504:
505: --dbms_output.put_line('Start of Raise_ServiceRequest_Event');
506:
507: -- Initialize return status to SUCCESS
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:
510: --INSERT INTO rm_tmp values (p_Incident_Number, 'In Start of BES wrapper ',rm_tmp_seq.nextval);
511:
512: IF ( p_Incident_Number IS NULL) THEN

Line 749: p_Contacts_Table(l_contact_index).SR_CONTACT_POINT_ID = FND_API.G_MISS_NUM ) THEN -- new contact

745:
746: WHILE l_contact_index IS NOT NULL LOOP
747:
748: IF (p_Contacts_Table(l_contact_index).SR_CONTACT_POINT_ID IS NULL OR
749: p_Contacts_Table(l_contact_index).SR_CONTACT_POINT_ID = FND_API.G_MISS_NUM ) THEN -- new contact
750:
751: l_contact_party_id := p_Contacts_Table(l_contact_index).PARTY_ID;
752: OPEN l_sel_party_name_csr;
753: FETCH l_sel_party_name_csr INTO l_contact_name;

Line 758: p_Contacts_table(l_contact_index).party_role_code = FND_API.G_MISS_CHAR OR

754:
755: IF (l_sel_party_name_csr%FOUND AND l_contact_name IS NOT NULL )THEN
756:
757: IF (p_Contacts_table(l_contact_index).party_role_code = 'CONTACT' OR
758: p_Contacts_table(l_contact_index).party_role_code = FND_API.G_MISS_CHAR OR
759: p_Contacts_table(l_contact_index).party_role_code IS NULL ) THEN
760:
761: -- Check for l_new_contact_point_name list length not to exceed 2000 .
762: IF (nvl(LENGTH(l_new_contact_point_name),0) + nvl(LENGTH(l_contact_name),0) + 1) <= 2000 THEN

Line 921: IF FND_API.To_Boolean(p_commit) THEN

917: /* Roopa - begin
918: Fix for bug 2798269
919: */
920: -- Standard check of p_commit
921: IF FND_API.To_Boolean(p_commit) THEN
922: COMMIT WORK;
923: END IF;
924: END IF;
925: END LOOP;

Line 962: IF FND_API.To_Boolean(p_commit) THEN

958: /* Roopa - begin
959: Fix for bug 2798269
960: */
961: -- Standard check of p_commit
962: IF FND_API.To_Boolean(p_commit) THEN
963: COMMIT WORK;
964: END IF;
965: -- commit;
966:

Line 1097: IF FND_API.To_Boolean(p_commit) THEN

1093: /* Roopa - begin
1094: Fix for bug 2798269
1095: */
1096: -- Standard check of p_commit
1097: IF FND_API.To_Boolean(p_commit) THEN
1098: COMMIT WORK;
1099: END IF;
1100: -- commit;
1101:

Line 1159: IF FND_API.To_Boolean(p_commit) THEN

1155: /* Roopa - begin
1156: Fix for bug 2798269
1157: */
1158: -- Standard check of p_commit
1159: IF FND_API.To_Boolean(p_commit) THEN
1160: COMMIT WORK;
1161: END IF;
1162: -- commit;
1163: --x_wf_process_id := l_event_id;

Line 1243: p_init_msg_list => FND_API.G_TRUE,

1239: --dbms_output.put_line('Calling Launch_Servereq_Workflow ');
1240:
1241: CS_Workflow_PUB.Launch_Servereq_Workflow(
1242: p_api_version => 1.0,
1243: p_init_msg_list => FND_API.G_TRUE,
1244: p_commit => p_commit,
1245: p_return_status => l_return_status,
1246: p_msg_count => l_msg_count,
1247: p_msg_data => l_msg_data,

Line 1253: p_nowait => FND_API.G_TRUE);

1249: p_initiator_user_id => p_USER_ID,
1250: p_initiator_resp_id => p_RESP_ID,
1251: p_initiator_resp_appl_id => p_RESP_APPL_ID,
1252: p_itemkey => l_itemkey,
1253: p_nowait => FND_API.G_TRUE);
1254:
1255: --dbms_output.put_line('Calling Launch_Servereq_Workflow,return status= '|| l_return_status);
1256:
1257: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1257: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1253: p_nowait => FND_API.G_TRUE);
1254:
1255: --dbms_output.put_line('Calling Launch_Servereq_Workflow,return status= '|| l_return_status);
1256:
1257: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1258: raise FND_API.G_EXC_ERROR;
1259: END IF;
1260:
1261: l_pos := INSTR(l_itemkey, '-',-1,1); -- Bug#4007088

Line 1258: raise FND_API.G_EXC_ERROR;

1254:
1255: --dbms_output.put_line('Calling Launch_Servereq_Workflow,return status= '|| l_return_status);
1256:
1257: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1258: raise FND_API.G_EXC_ERROR;
1259: END IF;
1260:
1261: l_pos := INSTR(l_itemkey, '-',-1,1); -- Bug#4007088
1262: x_wf_process_id := SUBSTR(l_itemkey, l_pos+1);

Line 1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1292:
1293: WHEN l_INVALID_EVENT_ARGS THEN
1294: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_ARGS ');
1295: --l_param_list.DELETE;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1298: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1299: 'Raise_ServiceRequest_Event' );
1300: END IF;

Line 1303: p_encoded => FND_API.G_FALSE );

1299: 'Raise_ServiceRequest_Event' );
1300: END IF;
1301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1302: p_data => x_msg_data,
1303: p_encoded => FND_API.G_FALSE );
1304:
1305: WHEN l_INVALID_EVENT_CODE THEN
1306: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1307: --l_param_list.DELETE;

Line 1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1304:
1305: WHEN l_INVALID_EVENT_CODE THEN
1306: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1307: --l_param_list.DELETE;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1311: 'Raise_ServiceRequest_Event' );
1312: END IF;

Line 1315: p_encoded => FND_API.G_FALSE );

1311: 'Raise_ServiceRequest_Event' );
1312: END IF;
1313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1314: p_data => x_msg_data,
1315: p_encoded => FND_API.G_FALSE );
1316:
1317: WHEN FND_API.G_EXC_ERROR THEN
1318: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_ERROR');
1319: --l_param_list.DELETE;

Line 1317: WHEN FND_API.G_EXC_ERROR THEN

1313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1314: p_data => x_msg_data,
1315: p_encoded => FND_API.G_FALSE );
1316:
1317: WHEN FND_API.G_EXC_ERROR THEN
1318: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_ERROR');
1319: --l_param_list.DELETE;
1320: IF (l_sel_request_csr%ISOPEN) THEN
1321: CLOSE l_sel_request_csr;

Line 1318: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_ERROR');

1314: p_data => x_msg_data,
1315: p_encoded => FND_API.G_FALSE );
1316:
1317: WHEN FND_API.G_EXC_ERROR THEN
1318: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_ERROR');
1319: --l_param_list.DELETE;
1320: IF (l_sel_request_csr%ISOPEN) THEN
1321: CLOSE l_sel_request_csr;
1322: END IF;

Line 1323: x_return_status := FND_API.G_RET_STS_ERROR;

1319: --l_param_list.DELETE;
1320: IF (l_sel_request_csr%ISOPEN) THEN
1321: CLOSE l_sel_request_csr;
1322: END IF;
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1325: p_data => x_msg_data,
1326: p_encoded => FND_API.G_FALSE );
1327:

Line 1326: p_encoded => FND_API.G_FALSE );

1322: END IF;
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1325: p_data => x_msg_data,
1326: p_encoded => FND_API.G_FALSE );
1327:
1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_UNEXPECTED_ERROR');
1330: --l_param_list.DELETE;

Line 1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1324: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1325: p_data => x_msg_data,
1326: p_encoded => FND_API.G_FALSE );
1327:
1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_UNEXPECTED_ERROR');
1330: --l_param_list.DELETE;
1331: IF (l_sel_request_csr%ISOPEN) THEN
1332: CLOSE l_sel_request_csr;

Line 1329: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_UNEXPECTED_ERROR');

1325: p_data => x_msg_data,
1326: p_encoded => FND_API.G_FALSE );
1327:
1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: --dbms_output.put_line('Exception : WHEN FND_API.G_EXC_UNEXPECTED_ERROR');
1330: --l_param_list.DELETE;
1331: IF (l_sel_request_csr%ISOPEN) THEN
1332: CLOSE l_sel_request_csr;
1333: END IF;

Line 1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1330: --l_param_list.DELETE;
1331: IF (l_sel_request_csr%ISOPEN) THEN
1332: CLOSE l_sel_request_csr;
1333: END IF;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1336: p_data => x_msg_data,
1337: p_encoded => FND_API.G_FALSE );
1338:

Line 1337: p_encoded => FND_API.G_FALSE );

1333: END IF;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1336: p_data => x_msg_data,
1337: p_encoded => FND_API.G_FALSE );
1338:
1339: WHEN OTHERS THEN
1340: --dbms_output.put_line('Exception : WHEN OTHERS');
1341: --l_param_list.DELETE;

Line 1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1338:
1339: WHEN OTHERS THEN
1340: --dbms_output.put_line('Exception : WHEN OTHERS');
1341: --l_param_list.DELETE;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1344: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1345: 'Raise_ServiceRequest_Event' );
1346: END IF;

Line 1349: p_encoded => FND_API.G_FALSE );

1345: 'Raise_ServiceRequest_Event' );
1346: END IF;
1347: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1348: p_data => x_msg_data,
1349: p_encoded => FND_API.G_FALSE );
1350:
1351:
1352:
1353: