246: and mp.organization_id = cssr.source_organization_id
247: and NVL(mp.process_enabled_flag, 'N') = 'Y'
248: ;
249:
250: FND_MESSAGE.set_name( 'GMF', 'GMF_SCR_PROCESS_ORG_ERROR' );
251: FND_MESSAGE.set_token( 'SOURCING_RULE_NAME', l_sourcing_rule_name );
252: FND_MESSAGE.set_token( 'PROCESS_ORG', l_organization_code );
253: o_error_code := -1;
254: o_error_msg := FND_MESSAGE.get;
247: and NVL(mp.process_enabled_flag, 'N') = 'Y'
248: ;
249:
250: FND_MESSAGE.set_name( 'GMF', 'GMF_SCR_PROCESS_ORG_ERROR' );
251: FND_MESSAGE.set_token( 'SOURCING_RULE_NAME', l_sourcing_rule_name );
252: FND_MESSAGE.set_token( 'PROCESS_ORG', l_organization_code );
253: o_error_code := -1;
254: o_error_msg := FND_MESSAGE.get;
255: RETURN;
248: ;
249:
250: FND_MESSAGE.set_name( 'GMF', 'GMF_SCR_PROCESS_ORG_ERROR' );
251: FND_MESSAGE.set_token( 'SOURCING_RULE_NAME', l_sourcing_rule_name );
252: FND_MESSAGE.set_token( 'PROCESS_ORG', l_organization_code );
253: o_error_code := -1;
254: o_error_msg := FND_MESSAGE.get;
255: RETURN;
256:
250: FND_MESSAGE.set_name( 'GMF', 'GMF_SCR_PROCESS_ORG_ERROR' );
251: FND_MESSAGE.set_token( 'SOURCING_RULE_NAME', l_sourcing_rule_name );
252: FND_MESSAGE.set_token( 'PROCESS_ORG', l_organization_code );
253: o_error_code := -1;
254: o_error_msg := FND_MESSAGE.get;
255: RETURN;
256:
257: EXCEPTION
258: WHEN NO_DATA_FOUND THEN
332:
333:
334: exception
335: when OTHERS then
336: FND_MESSAGE.SET_NAME( 'SQLGL', 'MRC_RATE_NOT_FOUND' );
337: FND_MESSAGE.SET_TOKEN( 'MODULE', null );
338: FND_MESSAGE.SET_TOKEN( 'FROM', rate.from_currency );
339: FND_MESSAGE.SET_TOKEN( 'TO', rate.to_currency );
340: FND_MESSAGE.SET_TOKEN( 'TRANS_DATE',
333:
334: exception
335: when OTHERS then
336: FND_MESSAGE.SET_NAME( 'SQLGL', 'MRC_RATE_NOT_FOUND' );
337: FND_MESSAGE.SET_TOKEN( 'MODULE', null );
338: FND_MESSAGE.SET_TOKEN( 'FROM', rate.from_currency );
339: FND_MESSAGE.SET_TOKEN( 'TO', rate.to_currency );
340: FND_MESSAGE.SET_TOKEN( 'TRANS_DATE',
341: FND_DATE.DATE_TO_CHARDATE( sysdate ) );
334: exception
335: when OTHERS then
336: FND_MESSAGE.SET_NAME( 'SQLGL', 'MRC_RATE_NOT_FOUND' );
337: FND_MESSAGE.SET_TOKEN( 'MODULE', null );
338: FND_MESSAGE.SET_TOKEN( 'FROM', rate.from_currency );
339: FND_MESSAGE.SET_TOKEN( 'TO', rate.to_currency );
340: FND_MESSAGE.SET_TOKEN( 'TRANS_DATE',
341: FND_DATE.DATE_TO_CHARDATE( sysdate ) );
342: FND_MESSAGE.SET_TOKEN( 'TYPE', i_conversion_type );
335: when OTHERS then
336: FND_MESSAGE.SET_NAME( 'SQLGL', 'MRC_RATE_NOT_FOUND' );
337: FND_MESSAGE.SET_TOKEN( 'MODULE', null );
338: FND_MESSAGE.SET_TOKEN( 'FROM', rate.from_currency );
339: FND_MESSAGE.SET_TOKEN( 'TO', rate.to_currency );
340: FND_MESSAGE.SET_TOKEN( 'TRANS_DATE',
341: FND_DATE.DATE_TO_CHARDATE( sysdate ) );
342: FND_MESSAGE.SET_TOKEN( 'TYPE', i_conversion_type );
343: APP_EXCEPTION.RAISE_EXCEPTION;
336: FND_MESSAGE.SET_NAME( 'SQLGL', 'MRC_RATE_NOT_FOUND' );
337: FND_MESSAGE.SET_TOKEN( 'MODULE', null );
338: FND_MESSAGE.SET_TOKEN( 'FROM', rate.from_currency );
339: FND_MESSAGE.SET_TOKEN( 'TO', rate.to_currency );
340: FND_MESSAGE.SET_TOKEN( 'TRANS_DATE',
341: FND_DATE.DATE_TO_CHARDATE( sysdate ) );
342: FND_MESSAGE.SET_TOKEN( 'TYPE', i_conversion_type );
343: APP_EXCEPTION.RAISE_EXCEPTION;
344: RETURN;
338: FND_MESSAGE.SET_TOKEN( 'FROM', rate.from_currency );
339: FND_MESSAGE.SET_TOKEN( 'TO', rate.to_currency );
340: FND_MESSAGE.SET_TOKEN( 'TRANS_DATE',
341: FND_DATE.DATE_TO_CHARDATE( sysdate ) );
342: FND_MESSAGE.SET_TOKEN( 'TYPE', i_conversion_type );
343: APP_EXCEPTION.RAISE_EXCEPTION;
344: RETURN;
345:
346: END;