DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on FND_MESSAGE

Line 367: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_ERROR');

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 ;

Line 368: G_FND_MSG_TYPE_ERROR := FND_MESSAGE.GET;

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:

Line 377: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_WARNING');

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 ;

Line 378: G_FND_MSG_TYPE_WARNING := FND_MESSAGE.GET;

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:

Line 388: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_INFORMATION');

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 ;

Line 389: G_FND_MSG_TYPE_INFORMATION := FND_MESSAGE.GET;

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:

Line 398: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_CONFIRMATION');

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 ;

Line 399: G_FND_MSG_TYPE_CONFIRMATION := FND_MESSAGE.GET;

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:

Line 1194: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);

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 )

Line 1195: l_error_msg_text := FND_MESSAGE.GET;

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

Line 1202: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);

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:

Line 1203: l_error_msg_text := FND_MESSAGE.GET;

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:

Line 2372: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');

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);

Line 2374: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');

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;

Line 2375: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);

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;

Line 2376: fnd_message.set_token('VALUE', l_msg_data);

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;

Line 2377: x_msg_data := fnd_message.get();

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;

Line 2392: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');

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;

Line 2394: x_msg_data := fnd_message.get();

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:

Line 2912: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');

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:

Line 2913: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);

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 := '';

Line 2914: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));

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 ';

Line 2915: l_error_msg := FND_MESSAGE.GET;

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 || '( ';

Line 3316: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');

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 := '';

Line 3317: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));

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 ';

Line 3318: l_error_msg := FND_MESSAGE.GET;

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 || '( ';

Line 5322: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');

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:

Line 5323: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));

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

Line 5324: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));

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

Line 5325: l_msg_text := FND_MESSAGE.GET;

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

Line 5462: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

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:

Line 5472: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

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;