[Home] [Help]
1078: l_return_status VARCHAR2(1);
1079: -- Added for making call to 11.5.10 signature of Create SR private API
1080: l_sr_create_out_rec sr_create_out_rec_type;
1081: BEGIN
1082: -- Standard start of API savepoint
1083: SAVEPOINT Create_ServiceRequest_PVT;
1084:
1085: -- Standard call to check for call compatibility
1086: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1081: BEGIN
1082: -- Standard start of API savepoint
1083: SAVEPOINT Create_ServiceRequest_PVT;
1084:
1085: -- Standard call to check for call compatibility
1086: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1087: G_PKG_NAME) THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1450: l_price_list_header_id NUMBER := NULL ;
1451:
1452: BEGIN
1453:
1454: -- Standard start of API savepoint
1455: SAVEPOINT Create_ServiceRequest_PVT;
1456:
1457: -- Standard call to check for call compatibility
1458: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1453:
1454: -- Standard start of API savepoint
1455: SAVEPOINT Create_ServiceRequest_PVT;
1456:
1457: -- Standard call to check for call compatibility
1458: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1459: G_PKG_NAME) THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
3307: -- Changed out parameter references to out rec references
3308: x_sr_create_out_rec.request_id := l_request_id;
3309: x_sr_create_out_rec.request_number := l_request_number;
3310:
3311: -- Standard call for message generation
3312: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
3313: 'Create_ServiceRequest',
3314: 'M', 'M') THEN
3315:
3381:
3382: /*resetting the parameter value shijain 4th dec 2002*/
3383: g_restrict_ib:=NULL;
3384:
3385: -- Standard call to get message count and if count is 1, get message info
3386: FND_MSG_PUB.Count_And_Get
3387: ( p_count => x_msg_count,
3388: p_data => x_msg_data
3389: );
3483: p_data => x_msg_data
3484: );
3485: END IF;
3486:
3487: -- Standard check of p_commit
3488: IF FND_API.To_Boolean(p_commit) THEN
3489: COMMIT WORK;
3490: END IF;
3491:
3577:
3578: l_sr_update_out_rec sr_update_out_rec_type;
3579:
3580: BEGIN
3581: -- Standard start of API savepoint
3582: SAVEPOINT Update_ServiceRequest_PVT;
3583:
3584: -- Standard call to check for call compatibility
3585: -- Added the and condition for backward compatibility project, now
3580: BEGIN
3581: -- Standard start of API savepoint
3582: SAVEPOINT Update_ServiceRequest_PVT;
3583:
3584: -- Standard call to check for call compatibility
3585: -- Added the and condition for backward compatibility project, now
3586: -- both the version 2.0 and 3.0 are valid as this procedure can be called
3587: -- from both 1158 or 1159 env.
3588: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
4077: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
4078:
4079: BEGIN
4080:
4081: -- Standard start of API savepoint
4082: SAVEPOINT Update_ServiceRequest_PVT;
4083:
4084: -- Standard call to check for call compatibility
4085: -- Added the and condition for backward compatibility project, now
4080:
4081: -- Standard start of API savepoint
4082: SAVEPOINT Update_ServiceRequest_PVT;
4083:
4084: -- Standard call to check for call compatibility
4085: -- Added the and condition for backward compatibility project, now
4086: -- both the version 2.0 and 3.0 are valid as this procedure can be called
4087: -- from both 1158 or 1159 env.
4088: -- The previous version, 3.0, is supported by the overloaded procedure. This API can be
6447: END IF; /* called by workflow */
6448: END IF; /* only status update flag check */
6449:
6450:
6451: -- Standard call for message generation
6452: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
6453: 'Create_ServiceRequest',
6454: 'M', 'M') THEN
6455:
6475:
6476: /***************************************************
6477: commented for bug 2857350, moved after calling the business events
6478:
6479: -- Standard check of p_commit
6480: IF FND_API.To_Boolean(p_commit) THEN
6481: COMMIT WORK;
6482: END IF;
6483: comments ended for bug 2857350
7093: END IF;
7094:
7095: CLOSE l_ServiceRequest_csr;
7096: /**************Commit moved for bug 2857350**************************/
7097: -- Standard check of p_commit
7098: IF FND_API.To_Boolean(p_commit) THEN
7099: COMMIT WORK;
7100: END IF;
7101:
7101:
7102: /*resetting the parameter value shijain 4th dec 2002*/
7103: g_restrict_ib:=NULL;
7104:
7105: -- Standard call to get message count and if count is 1, get message info
7106: FND_MSG_PUB.Count_And_Get (
7107: p_count => x_msg_count,
7108: p_data => x_msg_data );
7109:
7360: l_incident_resolved_date DATE;
7361: BEGIN
7362:
7363: -- ---------------------------------------
7364: -- Standard API stuff
7365: -- ---------------------------------------
7366:
7367: -- Establish save point
7368: SAVEPOINT Update_Status_PVT;
8349:
8350: BEGIN
8351:
8352: -- ---------------------------------------
8353: -- Standard API stuff
8354: -- ---------------------------------------
8355: -- Establish savepoint
8356: SAVEPOINT Update_Owner_PVT;
8357:
20924: l_individual_type VARCHAR2(30);
20925:
20926:
20927: BEGIN
20928: -- Standard start of API savepoint
20929: SAVEPOINT Create_ServiceRequest_PVT;
20930:
20931: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
20932: G_PKG_NAME) THEN
21053:
21054: --------------------------------------------------------------------------------
21055: -- Procedure Name : DELETE_SERVICEREQUEST
21056: --
21057: -- Parameters (other than standard ones)
21058: -- IN
21059: -- p_purge_set_id : Id that helps identify a set of SRs
21060: -- that were purged in a single batch
21061: -- p_processing_set_id : Id that helps the API in identifying