363: THEN
364:
365: IF G_FND_MSG_TYPE_ERROR IS NULL
366: THEN
367: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_ERROR');
368: G_FND_MSG_TYPE_ERROR := FND_MESSAGE.GET;
369: END IF ;
370:
371: l_msg_type_text := G_FND_MSG_TYPE_ERROR ;
364:
365: IF G_FND_MSG_TYPE_ERROR IS NULL
366: THEN
367: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_ERROR');
368: G_FND_MSG_TYPE_ERROR := FND_MESSAGE.GET;
369: END IF ;
370:
371: l_msg_type_text := G_FND_MSG_TYPE_ERROR ;
372:
373: ELSIF p_msg_type = WARNING
374: THEN
375: IF G_FND_MSG_TYPE_WARNING IS NULL
376: THEN
377: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_WARNING');
378: G_FND_MSG_TYPE_WARNING := FND_MESSAGE.GET;
379: END IF ;
380:
381: l_msg_type_text := G_FND_MSG_TYPE_WARNING ;
374: THEN
375: IF G_FND_MSG_TYPE_WARNING IS NULL
376: THEN
377: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_WARNING');
378: G_FND_MSG_TYPE_WARNING := FND_MESSAGE.GET;
379: END IF ;
380:
381: l_msg_type_text := G_FND_MSG_TYPE_WARNING ;
382:
384: ELSIF p_msg_type = INFORMATION
385: THEN
386: IF G_FND_MSG_TYPE_INFORMATION IS NULL
387: THEN
388: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_INFORMATION');
389: G_FND_MSG_TYPE_INFORMATION := FND_MESSAGE.GET;
390: END IF ;
391:
392: l_msg_type_text := G_FND_MSG_TYPE_INFORMATION ;
385: THEN
386: IF G_FND_MSG_TYPE_INFORMATION IS NULL
387: THEN
388: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_INFORMATION');
389: G_FND_MSG_TYPE_INFORMATION := FND_MESSAGE.GET;
390: END IF ;
391:
392: l_msg_type_text := G_FND_MSG_TYPE_INFORMATION ;
393:
394: ELSIF p_msg_type = CONFIRMATION
395: THEN
396: IF G_FND_MSG_TYPE_CONFIRMATION IS NULL
397: THEN
398: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_CONFIRMATION');
399: G_FND_MSG_TYPE_CONFIRMATION := FND_MESSAGE.GET;
400: END IF ;
401:
402: l_msg_type_text := G_FND_MSG_TYPE_CONFIRMATION ;
395: THEN
396: IF G_FND_MSG_TYPE_CONFIRMATION IS NULL
397: THEN
398: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_CONFIRMATION');
399: G_FND_MSG_TYPE_CONFIRMATION := FND_MESSAGE.GET;
400: END IF ;
401:
402: l_msg_type_text := G_FND_MSG_TYPE_CONFIRMATION ;
403:
1190: G_NO_BATCH = l_cm_import_option )
1191: THEN
1192:
1193: l_error_msg_name := 'ENG_IMPT_INVALID_BATCH_ID' ;
1194: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1195: l_error_msg_text := FND_MESSAGE.GET;
1196:
1197: ELSIF ( G_NO_CHANGE = l_cm_import_option OR
1198: l_cm_import_option IS NULL )
1191: THEN
1192:
1193: l_error_msg_name := 'ENG_IMPT_INVALID_BATCH_ID' ;
1194: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1195: l_error_msg_text := FND_MESSAGE.GET;
1196:
1197: ELSIF ( G_NO_CHANGE = l_cm_import_option OR
1198: l_cm_import_option IS NULL )
1199: THEN
1198: l_cm_import_option IS NULL )
1199: THEN
1200:
1201: l_error_msg_name := 'ENG_IMPT_NO_CM_OPTION' ;
1202: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1203: l_error_msg_text := FND_MESSAGE.GET;
1204:
1205: END IF ;
1206:
1199: THEN
1200:
1201: l_error_msg_name := 'ENG_IMPT_NO_CM_OPTION' ;
1202: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1203: l_error_msg_text := FND_MESSAGE.GET;
1204:
1205: END IF ;
1206:
1207:
2368: -- Logic Here
2369: -- Init Local Vars
2370: -- Init Index Text Item Attributes
2371: IF (p_batch_id IS NULL) THEN
2372: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2373: l_msg_data := fnd_msg_pub.get();
2374: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2375: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2376: fnd_message.set_token('VALUE', l_msg_data);
2370: -- Init Index Text Item Attributes
2371: IF (p_batch_id IS NULL) THEN
2372: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2373: l_msg_data := fnd_msg_pub.get();
2374: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2375: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2376: fnd_message.set_token('VALUE', l_msg_data);
2377: x_msg_data := fnd_message.get();
2378: x_msg_count := 1;
2371: IF (p_batch_id IS NULL) THEN
2372: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2373: l_msg_data := fnd_msg_pub.get();
2374: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2375: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2376: fnd_message.set_token('VALUE', l_msg_data);
2377: x_msg_data := fnd_message.get();
2378: x_msg_count := 1;
2379: x_return_status := G_RET_STS_ERROR;
2372: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2373: l_msg_data := fnd_msg_pub.get();
2374: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2375: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2376: fnd_message.set_token('VALUE', l_msg_data);
2377: x_msg_data := fnd_message.get();
2378: x_msg_count := 1;
2379: x_return_status := G_RET_STS_ERROR;
2380: RETURN;
2373: l_msg_data := fnd_msg_pub.get();
2374: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2375: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2376: fnd_message.set_token('VALUE', l_msg_data);
2377: x_msg_data := fnd_message.get();
2378: x_msg_count := 1;
2379: x_return_status := G_RET_STS_ERROR;
2380: RETURN;
2381: END IF;
2388: AND PROCESS_FLAG = G_CM_TO_BE_PROCESSED
2389: AND ROWNUM = 1;
2390: EXCEPTION
2391: WHEN NO_DATA_FOUND THEN
2392: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');
2393: x_msg_count := 1;
2394: x_msg_data := fnd_message.get();
2395: x_return_status := G_RET_STS_SUCCESS;
2396: RAISE NO_ROWS_IN_INTF_TABLE;
2390: EXCEPTION
2391: WHEN NO_DATA_FOUND THEN
2392: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');
2393: x_msg_count := 1;
2394: x_msg_data := fnd_message.get();
2395: x_return_status := G_RET_STS_SUCCESS;
2396: RAISE NO_ROWS_IN_INTF_TABLE;
2397: END;
2398:
2908: THEN
2909:
2910: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
2911:
2912: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
2913: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
2914: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
2915: l_error_msg := FND_MESSAGE.GET;
2916:
2909:
2910: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
2911:
2912: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
2913: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
2914: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
2915: l_error_msg := FND_MESSAGE.GET;
2916:
2917: l_dyn_sql := '';
2910: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
2911:
2912: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
2913: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
2914: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
2915: l_error_msg := FND_MESSAGE.GET;
2916:
2917: l_dyn_sql := '';
2918: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
2911:
2912: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
2913: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
2914: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
2915: l_error_msg := FND_MESSAGE.GET;
2916:
2917: l_dyn_sql := '';
2918: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
2919: l_dyn_sql := l_dyn_sql || '( ';
3312: IF FND_API.to_Boolean(l_write_msg_to_intftbl) THEN
3313:
3314: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3315:
3316: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');
3317: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3318: l_error_msg := FND_MESSAGE.GET;
3319:
3320: l_dyn_sql := '';
3313:
3314: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3315:
3316: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');
3317: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3318: l_error_msg := FND_MESSAGE.GET;
3319:
3320: l_dyn_sql := '';
3321: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
3314: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3315:
3316: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');
3317: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3318: l_error_msg := FND_MESSAGE.GET;
3319:
3320: l_dyn_sql := '';
3321: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
3322: l_dyn_sql := l_dyn_sql || '( ';
5318: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
5319: THEN
5320:
5321: Write_Debug('Insert Info Message for the record inserted as history. . .' );
5322: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');
5323: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5324: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5325: l_msg_text := FND_MESSAGE.GET;
5326:
5319: THEN
5320:
5321: Write_Debug('Insert Info Message for the record inserted as history. . .' );
5322: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');
5323: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5324: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5325: l_msg_text := FND_MESSAGE.GET;
5326:
5327: Insert_Mtl_Intf_Err
5320:
5321: Write_Debug('Insert Info Message for the record inserted as history. . .' );
5322: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');
5323: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5324: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5325: l_msg_text := FND_MESSAGE.GET;
5326:
5327: Insert_Mtl_Intf_Err
5328: ( p_transaction_id => null
5321: Write_Debug('Insert Info Message for the record inserted as history. . .' );
5322: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');
5323: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5324: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5325: l_msg_text := FND_MESSAGE.GET;
5326:
5327: Insert_Mtl_Intf_Err
5328: ( p_transaction_id => null
5329: , p_bo_identifier => G_BO_IDENTIFIER
5458: open c;
5459: fetch c into recinfo;
5460: if (c%notfound) then
5461: close c;
5462: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
5463: app_exception.raise_exception;
5464: end if;
5465: close c;
5466:
5468: OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
5469: ) then
5470: null;
5471: else
5472: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
5473: app_exception.raise_exception;
5474: end if;
5475:
5476: return;