94: x_error_segments NUMBER;
95: x_error_message VARCHAR2(5000);
96: BEGIN
97:
98: /* Standard Start of API savepoint */
99: SAVEPOINT Insert_PMSetName_PUB;
100:
101: /* Standard call to check for call compatibility. */
102: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
97:
98: /* Standard Start of API savepoint */
99: SAVEPOINT Insert_PMSetName_PUB;
100:
101: /* Standard call to check for call compatibility. */
102: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
103: p_api_version ,
104: l_api_name ,
105: G_PKG_NAME
244: p_organization_id ,
245: p_local_flag
246: );
247:
248: /* Standard check of p_commit. */
249: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
250: COMMIT WORK;
251: END IF;
252: /* Standard call to get message count and if count is 1, get message info. */
248: /* Standard check of p_commit. */
249: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
250: COMMIT WORK;
251: END IF;
252: /* Standard call to get message count and if count is 1, get message info. */
253: FND_MSG_PUB.get
254: ( p_msg_index_out => x_msg_count ,
255: p_data => x_msg_data
256: );
367: l_set_name_id number;
368:
369: BEGIN
370:
371: /* Standard Start of API savepoint */
372: SAVEPOINT Update_PMSetName_PUB;
373:
374: /* Standard call to check for call compatibility. */
375: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
370:
371: /* Standard Start of API savepoint */
372: SAVEPOINT Update_PMSetName_PUB;
373:
374: /* Standard call to check for call compatibility. */
375: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
376: p_api_version ,
377: l_api_name ,
378: G_PKG_NAME
556: WHERE
557: set_name_id = l_set_name_id;
558:
559:
560: /* Standard check of p_commit. */
561: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
562: COMMIT WORK;
563: END IF;
564: /* Standard call to get message count and if count is 1, get message info. */
560: /* Standard check of p_commit. */
561: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
562: COMMIT WORK;
563: END IF;
564: /* Standard call to get message count and if count is 1, get message info. */
565: FND_MSG_PUB.get
566: ( p_msg_index_out => x_msg_count ,
567: p_data => x_msg_data
568: );